topic Re: List Box help? in QlikView

List Box help?

Anonymous — Thu, 19 Mar 2015 14:04:13 GMT

Long story short I created a pivot query in SQL for the below and now I'm looking for a way to group multiple values into a list box.

ID Address Apple Orange Banana

1 100 Y

2 200 Y

3 100 Y Y

4 500 Y

7 ETC...

I would like to create a listbox that has the pivot values, in this case Apple, Orange and Banana and if there is a Y in their column then filter on those results...

List box

Apple

Orange

Banana

Re: List Box help?

marcus_sommer — Thu, 19 Mar 2015 14:11:01 GMT

Have a look here:

The Crosstable Load

- Marcus

Re: List Box help?

Anonymous — Thu, 19 Mar 2015 14:17:20 GMT

Okay, fairly new at Qliview. I would create a Resident load of the data from the SQL pivot and Crosstable that data?

Re: List Box help?

stigchel — Thu, 19 Mar 2015 14:22:44 GMT

Something like this:

Pivot:

Load * Inline [ID,Address,Apple,Orange,Banana

1,100,N,N,Y

2,200,Y,Y,N

3,100,Y,Y,N

4,500,N,N,Y

];

CrossTable (Fuit,Data,2) load

ID,

Address,

if(Apple='Y',Apple) as Apple,

if(Orange='Y',Orange) as Orange,

if(Banana='Y',Banana) as Banana

resident Pivot;

DROP Table Pivot;

Re: List Box help?

stigchel — Wed, 25 Mar 2015 10:00:32 GMT

Has this answered your question? If so, can you please close this thread by marking one of the answers correct? It will help others find a (correct) answer to similar problems and lets other contributing members know that this requires no more attention.