topic Re: list box (?) for data cross several columns in QlikView

list box (?) for data cross several columns

Wed, 25 Feb 2015 22:16:36 GMT

Extreme noob here, please bear with me.

I need to analyze similar data across several columns:

Shopper	Product 1	Product 2	Product 3
1	Apple	Orange
2	Banana	Apple	Orange
3	Orange

How can I create a List Box (or other object) to capture the data across the different columns?

Many Thanks, Frank

maxgro — Thu, 26 Feb 2015 11:22:43 GMT

LOAD Shopper,

[Product 1],

[Product 2],

[Product 3],

FROM

(html, codepage is 1252, embedded labels, table is @1);

t2:

load Shopper, 1 as ProductNumber, [Product 1] as Product Resident t where len(Trim([Product 1]))>0;

load Shopper, 2 as ProductNumber, [Product 2] as Product Resident t where len(Trim([Product 2]))>0;

load Shopper, 3 as ProductNumber, [Product 3] as Product Resident t where len(Trim([Product 3]))>0;

then add a straight table chart

see attachment

Thu, 26 Feb 2015 15:01:16 GMT

That solves it. Thank you Massimo !