Qlik Community

QlikView Documents

QlikView documentation and resources.

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

Clear Selections of all table fields in set analysis

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

Clear Selections of all table fields in set analysis

Hello

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:

SUM({$<

    $(i_clear_table_fields(_tablename_))

    >}

    _expression_

)

Replace _tablename_ with table name you want to clear.

Cheers

Darius

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