topic Re: Toggle a filter when any selection is made in QlikView

Toggle a filter when any selection is made

Thu, 13 Dec 2012 17:20:57 GMT

Hi all,

I am hoping this is a simple trigger that I am missing. Basically my sheet right now has about 15 options the user can select from, with many choices per selection. There are 4 multi boxes with 3-4 dimensions in each box with many choices per dimension.

I have a Current Selections Box in the upper right to show the users their current filters.

When a user opens the program, I would like a text box to say something like "No Filters Selected." Then if the user selects anything, the box should say "Number of Records with current filters: x" I already wrote the expression count based on number of rows to change x to a real number.

So is there a way to do this? My thought is to change what a variable says when something is selected?

Thanks so much.

Re: Toggle a filter when any selection is made

MayilVahanan — Thu, 13 Dec 2012 17:58:57 GMT

Try like this in text box:

=if(Len(GetCurrentSelections())=0,'No Filters Selected','Number of selections selected '&your expression)

Re: Toggle a filter when any selection is made

Mon, 17 Dec 2012 14:18:35 GMT

Thanks, that worked perfectly!

Re: Toggle a filter when any selection is made

Mon, 17 Dec 2012 14:48:28 GMT

Hi, can you please provide your expression to get the no if rows chnaged with current selections?

Re: Toggle a filter when any selection is made

Mon, 17 Dec 2012 15:50:14 GMT

Here's my expression in full:

=if(len(GetCurrentSelections())=0,'No Filters Selected: '&num(count([Account #]),'##,###')&' total records',

'Number of Records with current filters: '&num(count(Account #]),'##,###'))