topic Check if any table field is filtered by user in QlikView

Check if any table field is filtered by user

hugmarcel — Thu, 29 Mar 2012 08:35:46 GMT

I have a table A with fields field1, field2, field3, ..., field20. There is a listbox for every field.

How can I check in a pivot formula, if any of the table A fields is filtered in the listbox by the user?

Thx - Marcel

Check if any table field is filtered by user

SunilChauhan — Thu, 29 Mar 2012 08:41:47 GMT

take a Current selection box

it will show you all selection by user.

hope this helps

Check if any table field is filtered by user

hugmarcel — Thu, 29 Mar 2012 08:59:10 GMT

and how to check / evaluate the content of the Current selection box in the pivot formula?

Check if any table field is filtered by user

Fri, 18 May 2012 06:27:39 GMT

You can try the getfieldselections() function. It will allow you output the text of the currently active selections for a particular field. You can also specify the separator to go between the text in the case of multiple active selections in a single field.

Check the manual for details on getfieldselections(). Hope this helps!