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 Ashutosh,

I have used your code but when I am deselecting, It is not hiding the resp field.

[CELAMBARASAN]

Hi Ashutosh,

     Yes,You are right need to mention max values if the field has more than 6 values.

Celambarasan

[#4]

Hi,

Try this if it also does not work then let me know.

for channel

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

for country

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

...

Ashutosh

[#5]

The above one will work also this one will also work

for channel

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

for country

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

I had missed 0 earlier.

..

Ashutosh

[#6]

Thanks a lot Ashutosh.........this is really working......

[#7]

Thanks