Clear Selections of all table fields in set analysis

Hello

 

Recently I find very good document about clearing fields in set analysis http://community.qlikview.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:

 

 

SUM({$<

    $(i_clear_table_fields(_tablename_))

    >}

    _expression_

)

 

 

Replace _tablename_ with table name you want to clear.

 

Cheers

Darius