Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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;