topic Nested filter fields in Water Cooler

Nested filter fields

Wed, 11 Apr 2012 05:14:44 GMT

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

Nested filter fields

Wed, 11 Apr 2012 05:37:58 GMT

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

Nested filter fields

Wed, 11 Apr 2012 07:26:53 GMT

Hi Ashutosh,

Please tell me exactly wer to use the conditional split .

Thank you

Re: Nested filter fields

Wed, 11 Apr 2012 08:30:42 GMT

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

Nested filter fields

Wed, 11 Apr 2012 08:49:17 GMT

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.

Nested filter fields

CELAMBARASAN — Wed, 11 Apr 2012 08:57:35 GMT

Hi,

What expression you have used?

Celambarasan

Nested filter fields

Wed, 11 Apr 2012 09:01:58 GMT

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

Nested filter fields

CELAMBARASAN — Wed, 11 Apr 2012 09:10:00 GMT

Hi,

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

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

Nested filter fields

Wed, 11 Apr 2012 09:19:21 GMT

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

Nested filter fields

Wed, 11 Apr 2012 09:22:16 GMT

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

Nested filter fields

Wed, 11 Apr 2012 09:31:30 GMT

Hi Ashutosh,

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

Nested filter fields

CELAMBARASAN — Wed, 11 Apr 2012 09:41:49 GMT

Hi Ashutosh,

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

Celambarasan

Re: Nested filter fields

Wed, 11 Apr 2012 09:47:57 GMT

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

Re: Nested filter fields

Wed, 11 Apr 2012 09:51:32 GMT

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

Nested filter fields

Wed, 11 Apr 2012 11:20:08 GMT

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

Nested filter fields

Wed, 11 Apr 2012 11:22:20 GMT

Thanks