topic Re: Combine from 3 variable to 1 in QlikView

Combine from 3 variable to 1

Anonymous — Fri, 15 Nov 2013 20:48:17 GMT

Hi guys,

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

Please see below

What's the best way to do it?

Regards,

Vladimir

Re: Combine from 3 variable to 1

swuehl — Fri, 15 Nov 2013 20:54:12 GMT

What do you expect as result?

Have you considered concatenating the three fields

Choice1 & Choice2 & Choice3

Re: Combine from 3 variable to 1

Anonymous — Fri, 15 Nov 2013 20:57:54 GMT

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

thanks,

Re: Combine from 3 variable to 1

Anonymous — Fri, 15 Nov 2013 21:00:42 GMT

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.

Re: Re: Combine from 3 variable to 1

Anonymous — Fri, 15 Nov 2013 21:06:13 GMT

Look on attached exmple.

Re: Combine from 3 variable to 1

swuehl — Fri, 15 Nov 2013 21:22:10 GMT

Or try a CROSSTABLE Load

CROSSTABLE (Choice, Value)

LOAD

Name,

Choice1, Choice2,Choice3

FROM YourTable;