Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
vovan4ik
Specialist II
Specialist II

Combine from 3 variable to 1

Hi guys,

I have 3 variables and I want to combined them to 1 variable.

Please see below

Capture.JPG.jpg

What's the best way to do it?

Regards,

Vladimir

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Or try a CROSSTABLE Load

CROSSTABLE (Choice, Value)

LOAD

     Name,

Choice1, Choice2,Choice3

FROM YourTable;

View solution in original post

5 Replies
swuehl
MVP
MVP

What do you expect as result?

Have you considered concatenating the three fields

Choice1 & Choice2 & Choice3

vovan4ik
Specialist II
Specialist II
Author

I need to create list box, where I can see only aa, bb, cc and etc.

thanks,

jaswantc
Creator II
Creator II

Try like this

 

Result_Table:

LOAD Name,
Choice1 as Choice
Resident input;

Result_Table:
LOAD Name,
Choice2 as Choice
Resident input;

Result_Table:
LOAD Name,
Choice3 as Choice
Resident input;

Then drop orginal table.

jaswantc
Creator II
Creator II

Look on attached exmple.

swuehl
MVP
MVP

Or try a CROSSTABLE Load

CROSSTABLE (Choice, Value)

LOAD

     Name,

Choice1, Choice2,Choice3

FROM YourTable;