Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Can we union Two fields values in one list box

Hi Team,

Can we union Two fields values in one list box?

Lets say if I have two fields F2 and F3 whit list values F2(1,2,3,4), F3(5,6,7).

I need to display 1,2,3,4,5,6,7 in one list box.

can we manage to do this using expression in list box?

Please find the attached qvw.

Thanks & Regards,

MVV Satish.


1 Solution

Accepted Solutions

Re: Can we union Two fields values in one list box

Yes, and it will be totally useless:

=ValueList($(=Concat({1<F2={'*'}>}Distinct chr(39) &  F2 & chr(39), ',') & ',' & Concat({1<F3={'*'}>}Distinct chr(39) &  F3 & chr(39), ',') ))

Concatenate your two tables in the script:

Tab:

LOAD *, 'Tab1' as Source INLINE [

    F1, F2

    V, 1

    V, 2

    V, 3

    V, 4

];

LOAD F1, F3 as F2, 'Tab2' as Source INLINE [

    F1, F3

    B, 5

    B, 6

    B, 7

];


talk is cheap, supply exceeds demand
1 Reply

Re: Can we union Two fields values in one list box

Yes, and it will be totally useless:

=ValueList($(=Concat({1<F2={'*'}>}Distinct chr(39) &  F2 & chr(39), ',') & ',' & Concat({1<F3={'*'}>}Distinct chr(39) &  F3 & chr(39), ',') ))

Concatenate your two tables in the script:

Tab:

LOAD *, 'Tab1' as Source INLINE [

    F1, F2

    V, 1

    V, 2

    V, 3

    V, 4

];

LOAD F1, F3 as F2, 'Tab2' as Source INLINE [

    F1, F3

    B, 5

    B, 6

    B, 7

];


talk is cheap, supply exceeds demand
Community Browser