Discussion Board for collaboration related to QlikView App Development.
I have 3 variables and I want to combined them to 1 variable.
Please see below
What's the best way to do it?
Or try a CROSSTABLE Load
CROSSTABLE (Choice, Value)
View solution in original post
What do you expect as result?
Have you considered concatenating the three fields
Choice1 & Choice2 & Choice3
I need to create list box, where I can see only aa, bb, cc and etc.
Try like this
LOAD Name,Choice1 as ChoiceResident input;Result_Table:LOAD Name,Choice2 as ChoiceResident input;Result_Table:LOAD Name,Choice3 as ChoiceResident input;
Then drop orginal table.
Look on attached exmple.