Nested filter fields

[#1]

Hi,

Can anyone tell me how can we do this through qlikview ??

'Rows' is the first filter field in checkbox, when will select something like Channel and segment from Rows then data for Channel and segment will be show to the next in listbox.

As soon as will select values like Online store(ONL) from Channel listbox and Consumer from Segment listbox, will get sale data for Online store(ONL) and Consumer in a table .

Thank you,

Minakshi

[#2]

Hi Minakshi,

You can do this through conditional show.

Make list boxes for channel and segment then if rows = channel or rows = segments then show their respective listboxes.

then if in channel and segments ONL and consumer is selected show your table.

You just need to work it out to fit your needs but this can be handled pretty well using conditional show.

Hope this makes sense.

..

Ashutosh

[#3]

Hi Ashutosh,

Please tell me exactly wer to use the conditional split .

Thank you

[#4 · Accepted solution]

Hi Minakshi,

When you go to list box properties, under layout tab you will see this option and here you can put your conditions.

Same will be available in charts also, if you are not able to make it work then please let me know.

I will make some sample and put it here. So, you will get an idea.

Thanks,

Ashutosh

[#5]

Ya I did the same when I am selecting Channel, Channel listbox is coming and when I am selecting Country, Countrylistbox is coming but when I am selecting both nothing is coming.

[CELAMBARASAN]

Hi,    

     What expression you have used?

Celambarasan

[#7]

In Channel listbox layout I have written Rows= 'Channel'

[CELAMBARASAN]

Hi,

     try this expression
     =WildMatch(GetFieldSelections(Rows,','),'*Channel*') for Channel list box

     =WildMatch(GetFieldSelections(Rows,','),'*Country*') for Country list box

[#9]

Hi Minakshi,

You can use something like this

for channel

=if(index(getfieldselections(Rows,'|',10),'channel')<>0,1)

for country

=if(index(getfieldselections(Rows,'|',10),'country')<>0,1)

this way even if you select both then also, it will work.

One more thing, instead of using 10 you can use total no. of distinct values in your Rows field, so if you have 4 distinct values in Rows then use 4.

This will be a little slower because here it needs to search through a longer string.

..

Ashutosh

[#10]

Hi Celambarasan,

it is very important to use max_values value in getfieldselctions (for example, I have used 10) function because if more than 6 values are selcted then it will return false even if it should return true.

...

Ashutosh