Qlik Community

QlikView Documents

QlikView documentation and resources.

Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Clear Selections of all table fields in set analysis

Showing results for 
Search instead for 
Did you mean: 
Partner - Creator III
Partner - Creator III

Clear Selections of all table fields in set analysis


Recently I find very good document about clearing fields in set analysis http://community.qlik.com/docs/DOC-1334 and decided to experiment a little bit with the approach. And then came up with following solution.

Suposse we need to clear all selections in all fields of particular table, i.e Calendar.

We need to create a variable i_clear_table_fields and set it's value to

$(='[' &CONCAT({1<$Table = {'$1'}>} DISTINCT $Field, '],[') & ']').

And then we can use it simillar to this:






Replace _tablename_ with table name you want to clear.



Labels (1)
Version history
Last update:
‎2012-04-23 01:12 PM
Updated by: