topic Re: changing column into row in QlikView

changing column into row

qlikapple — Sat, 16 Nov 2024 03:46:50 GMT

Hi all , can anyone pleae help me, as it is very urgent

CRNO

OUTID

ONLINE

DEGRADED

MINUTES

CR2578038

Actually the requirement is ther is one filed called Outscopewhich is either online or degraded, I have to keep the flags Y or N

so in the backend I have creaated flags for both and cretaed 2 fileds like below

if(MATCH(SCOPE_NAME,'DEGRADED'),'Y','N') as DEGRADESCOPE,

if(MATCH(SCOPE_NAME,'ONLINE'),'Y','N') as ONLINESCOPE,

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

I need to bring like this

CRNO

ONLINE

DEGRADED

ONLINEMINUTES

Degrade MINUTES

CR2578038

I want like above , how to do in back end, I need to get in the same row

Re: changing column into row

zhadrakas — Wed, 24 Apr 2019 07:20:09 GMT

Here is a script that should fit your Needs:
Replace the first Inline Load with your current Load Statement.

TEST:
LOAD * INLINE [
CRNO, OUTID, ONLINE, DEGRADED, MINUTES
CR2578038, 1, N, Y, 10
CR2578038, 2, N, Y, 20
CR2578038, 3, Y, N, 30
CR2578038, 4, Y, N, 40
];

TEST_AGG:
Load CRNO,
sum(if(ONLINE='Y', MINUTES)) as ONLINE_MINUTES,
sum(if(DEGRADED='Y', MINUTES)) as DEGRADE_MINUTES
Resident TEST
GROUP BY CRNO
;

Re: changing column into row

qlikapple — Wed, 24 Apr 2019 10:17:05 GMT

I am not gettting as excepted

The below one is original ouput which i want

Change Order Number

Disruptive change (Full)

Full Outage Minutes

Disruptive change (Degraded)

Degraded Outage minutes

Disruptive Free change

Incident Number

CR2574825

331

22,447

IN44448108

as I have done that but I am getting like this

in the script, I have wriiten like this

Change Order Number

Disruptive change (Full)

Full Outage Minutes

Disruptive change (Degraded)

Degraded Outage minutes

Disruptive Free change

Incident Number

CR2574825

331

22,447

IN44448108

as I have done that but I am getting like this

in the script, I have wriiten like this

Re: changing column into row

qlikapple — Wed, 24 Apr 2019 10:20:54 GMT

HI ,

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

can anyone please check

Re: changing column into row

qlikapple — Wed, 24 Apr 2019 11:26:47 GMT

Anyone please check

Re: changing column into row

qlikapple — Wed, 24 Apr 2019 12:01:33 GMT

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 2312