topic Search in 2 columns Based on 1 ListBox selection in QlikView

Search in 2 columns Based on 1 ListBox selection

Wed, 22 Jan 2014 10:45:18 GMT

I have the following records

Rolling 12 Month	Rolling 6 Month	Topic
1	1	Topic 1
1	1	Topic 2
1	0	Topic 3
1	0	Topic 4
0	0	Topic 5

Also I have a Inline data table:

Load * INLINE [

DateRange

Rolling 6 Month

Rolling 12 Month

];

Now I Create ListBox for DateRange and I'd like to make the Topic selection based on this ListBox selection

Re: Search in 2 columns Based on 1 ListBox selection

maxgro — Wed, 22 Jan 2014 11:47:11 GMT

I suppose that you can use field events trigger, see attachment

In the menu go to Settings --> Document Properties --> Triggers and on Field Event Triggers choose the field (the one of the listbox) DateRange, then OnSelect --> Add Action(s)

in Windoww Actions add 2 Actions

Select in Field [Rolling 6 Month] =if(GetFieldSelections(DateRange)='Rolling 6 Month', 1)

Select in Field [Rolling 12 Month] =if(GetFieldSelections(DateRange)='Rolling 12 Month', 1)

Re: Search in 2 columns Based on 1 ListBox selection

Wed, 22 Jan 2014 13:55:48 GMT

Thanks. But It's not working in case when dataset can't find any record. It just doesn't do anything

Re: Search in 2 columns Based on 1 ListBox selection

maxgro — Wed, 22 Jan 2014 14:52:28 GMT

just another attempt with a different approach