Qlik Community

QlikView Documents

Documents for QlikView related information.

Clear Selections of all table fields in set analysis

d_pranskus
Contributor 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
Revision #:
1 of 1
Last update:
‎04-23-2012 01:12 PM
Updated by: