topic changing column into row in QlikView App Dev
https://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572471#M741114
<P> </P><P>Hi all , can anyone pleae help me, as it is very urgent</P><P> </P><TABLE><TBODY><TR><TD>CRNO</TD><TD>OUTID</TD><TD>ONLINE</TD><TD>DEGRADED</TD><TD>MINUTES</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>CR2578038</TD><TD>1</TD><TD>N</TD><TD>Y</TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>2</TD><TD>N</TD><TD>Y</TD><TD>20</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>3</TD><TD>Y</TD><TD>N</TD><TD>30</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>4</TD><TD>Y</TD><TD>N</TD><TD>40</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Actually the requirement is ther is one filed called Outscopewhich is either online or degraded, I have to keep the flags Y or N</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>so in the backend I have creaated flags for both and cretaed 2 fileds like below</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>if(MATCH(SCOPE_NAME,'DEGRADED'),'Y','N') as DEGRADESCOPE,</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>if(MATCH(SCOPE_NAME,'ONLINE'),'Y','N') as ONLINESCOPE,</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Now my requirement is there is one field called Minutes, similarly I have to diffrenetiate the sum of the ONLine minutes and sum of the Degraded minutes</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>I need to bring like this</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>CRNO</TD><TD>ONLINE</TD><TD>DEGRADED</TD><TD>ONLINEMINUTES</TD><TD>Degrade MINUTES</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>CR2578038</TD><TD>N</TD><TD>Y</TD><TD>30</TD><TD>70</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>I want like above , how to do in back end, I need to get in the same row</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>Wed, 25 Nov 2020 16:16:04 GMTqlikapple2020-11-25T16:16:04Zchanging column into row
https://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572471#M741114
<P> </P><P>Hi all , can anyone pleae help me, as it is very urgent</P><P> </P><TABLE><TBODY><TR><TD>CRNO</TD><TD>OUTID</TD><TD>ONLINE</TD><TD>DEGRADED</TD><TD>MINUTES</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>CR2578038</TD><TD>1</TD><TD>N</TD><TD>Y</TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>2</TD><TD>N</TD><TD>Y</TD><TD>20</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>3</TD><TD>Y</TD><TD>N</TD><TD>30</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>4</TD><TD>Y</TD><TD>N</TD><TD>40</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Actually the requirement is ther is one filed called Outscopewhich is either online or degraded, I have to keep the flags Y or N</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>so in the backend I have creaated flags for both and cretaed 2 fileds like below</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>if(MATCH(SCOPE_NAME,'DEGRADED'),'Y','N') as DEGRADESCOPE,</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>if(MATCH(SCOPE_NAME,'ONLINE'),'Y','N') as ONLINESCOPE,</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Now my requirement is there is one field called Minutes, similarly I have to diffrenetiate the sum of the ONLine minutes and sum of the Degraded minutes</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>I need to bring like this</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>CRNO</TD><TD>ONLINE</TD><TD>DEGRADED</TD><TD>ONLINEMINUTES</TD><TD>Degrade MINUTES</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>CR2578038</TD><TD>N</TD><TD>Y</TD><TD>30</TD><TD>70</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>I want like above , how to do in back end, I need to get in the same row</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>Wed, 25 Nov 2020 16:16:04 GMThttps://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572471#M741114qlikapple2020-11-25T16:16:04ZRe: changing column into row
https://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572477#M741115
Here is a script that should fit your Needs:<BR />Replace the first Inline Load with your current Load Statement.<BR /><BR />TEST:<BR />LOAD * INLINE [<BR />CRNO, OUTID, ONLINE, DEGRADED, MINUTES<BR />CR2578038, 1, N, Y, 10<BR />CR2578038, 2, N, Y, 20<BR />CR2578038, 3, Y, N, 30<BR />CR2578038, 4, Y, N, 40<BR />];<BR /><BR />TEST_AGG:<BR />Load CRNO,<BR />sum(if(ONLINE='Y', MINUTES)) as ONLINE_MINUTES,<BR />sum(if(DEGRADED='Y', MINUTES)) as DEGRADE_MINUTES<BR />Resident TEST<BR />GROUP BY CRNO<BR />;Wed, 24 Apr 2019 07:20:09 GMThttps://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572477#M741115zhadrakas2019-04-24T07:20:09ZRe: changing column into row
https://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572600#M741116
<P>I am not gettting as excepted</P><P> </P><P> </P><P>The below one is original ouput which i want</P><TABLE><TBODY><TR><TD>Change Order Number</TD><TD>Disruptive change (Full)</TD><TD>Full Outage Minutes</TD><TD>Disruptive change (Degraded)</TD><TD>Degraded Outage minutes</TD><TD>Disruptive Free change</TD><TD>Incident Number</TD><TD> </TD></TR><TR><TD>CR2574825</TD><TD>Y</TD><TD>331</TD><TD>N</TD><TD>22,447</TD><TD>N</TD><TD>IN44448108</TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>as I have done that but I am getting like this</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD><TABLE><TBODY><TR><TD> </TD></TR></TBODY></TABLE></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>in the script, I have wriiten like this</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><TABLE><TBODY><TR><TD>Change Order Number</TD><TD>Disruptive change (Full)</TD><TD>Full Outage Minutes</TD><TD>Disruptive change (Degraded)</TD><TD>Degraded Outage minutes</TD><TD>Disruptive Free change</TD><TD>Incident Number</TD><TD> </TD></TR><TR><TD>CR2574825</TD><TD>Y</TD><TD>331</TD><TD>N</TD><TD>22,447</TD><TD>N</TD><TD>IN44448108</TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>as I have done that but I am getting like this</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD><TABLE><TBODY><TR><TD> </TD></TR></TBODY></TABLE></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>in the script, I have wriiten like this</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><P> </P><P> </P>Wed, 24 Apr 2019 10:17:05 GMThttps://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572600#M741116qlikapple2019-04-24T10:17:05ZRe: changing column into row
https://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572601#M741117
<P>HI ,</P><P>please find the attached , i am not getting the Output as expected, please find the first one which i need like this, but i am getting like second one</P><P>can anyone please check</P>Wed, 24 Apr 2019 10:20:54 GMThttps://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572601#M741117qlikapple2019-04-24T10:20:54ZRe: changing column into row
https://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572656#M741118
<P>Anyone please check</P>Wed, 24 Apr 2019 11:26:47 GMThttps://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572656#M741118qlikapple2019-04-24T11:26:47ZRe: changing column into row
https://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572676#M741119
please find the dummy data CRNO OUTSCOPE OUTAGEMINUTES IN NO 1234 ONLINE 32 11234 1234 DEGRADE 11234 2341 ONLINE 21 ABC 2341 DEGRADE 32 ABC 2341 ONLINE 43 ABC 123456 DEGRADE 21 2312 123456 DEGRADE 32 2312 123456 DEGRADE 21 2312 123456 ONLNE 21 2312 The requirement is like this , I want to show IN NO as single(unique) so that it should not repeat again , Now I want the o/p as CRNO OUTSCOPE(ONLINE Y) ONLINE MINUTES OUTSCOPE(DEGARDE Y) DEGRADE MINUTES IN NO 1234 Y 32 N 0 11234 2341 Y 21 Y 75 ABC 123456 Y 21 Y 74 2312Wed, 24 Apr 2019 12:01:33 GMThttps://community.qlik.com/t5/QlikView-App-Dev/changing-column-into-row/m-p/1572676#M741119qlikapple2019-04-24T12:01:33Z