Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Need to union three column values in one column

Hello Everyone,

Can you please look into the attached excel and help me to get the expected output.

I have Data sheet, my data is like in the sheet one.

but i wanted to get the data in the sheet "Expected Output",

but the values should show the same.

For example for ID 1 i have three managers and room count is 12, in the expected output it should show the 12 for three managers, if you select three managers ata  time it should show 12 only, not 36.

Thanks in advance

Tags (1)
5 Replies

Re: Need to union three column values in one column

Hi,

If possible can you post sample apps?

and What expression have you tried?

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Need to union three column values in one column

Hi,

Try this, have a look at attached application too.

LOAD ID,

     Manager1 as Manager,

     Rooms

FROM

[Managers List.xlsx]

(ooxml, embedded labels, table is Data);

Concatenate

LOAD ID,

    Manager2 as Manager, 

    Rooms

FROM

[Managers List.xlsx]

(ooxml, embedded labels, table is Data);

Concatenate

LOAD ID,

     Manager3 as Manager,

     Rooms

FROM

[Managers List.xlsx]

(ooxml, embedded labels, table is Data);

Regards

ASHFAQ

MVP
MVP

Re: Need to union three column values in one column

CrossTable(ManagersType, Managers, 2)

Load ID, Rooms, Manager1, Manager2, Manager3;

Load * Inline [

ID,Manager1,Manager2,Manager3,Rooms

1,AAA,BBB,CCC,12

2,DDD,EEE,FFF,43

3,GGG,HHH,III,22

4,JJJ,KKK,LLL,11

5,MMM,NNN,OOO,22

];

PFA

Not applicable

Re: Need to union three column values in one column

Hi Ashfaq,

Thanks for the response

I tried it, but all the time the expression is stopped working where i used manager column,

Please suggest what to do

Re: Need to union three column values in one column

Hi

Can you attach sample to look over

Regards

ASHFAQ