topic Dimension Restrictions using expression in QlikView

Dimension Restrictions using expression

Fri, 14 Jan 2011 14:19:48 GMT

Hi ,

Im looking to restrict my dimension to show the following:

Always show [Care Group] that equal ' ALL CBU'
In addition show Care Groups form the user selection list.

In the example below the result should be to show all [SECTION] that equal 'ALL CBU' and the user selection 'CBU 1 - Emergency...'.

The problem is though its only showing 'ALL CBU'.

Any ideas?

Dimension Restrictions using expression

johnw — Sat, 15 Jan 2011 02:53:41 GMT

I'm not sure what you mean by "restrict my dimension". Like you have a chart, and you always want to show ALL CBU, and also want to show whatever the user has selected? Perhaps use set analysis on the chart expression. Like if you have an expression count(Customer), you might modify it like this:

count({<"Care Group"+={'ALL CBU'}>} Customer)