topic Excluding selections for expression with set modifiers in QlikView

Excluding selections for expression with set modifiers

Wed, 01 Feb 2012 21:04:57 GMT

In my QV document I have 3 rows of data. The first row is the row that I would like to have change based on the current selections. The second is a total row that should remain static and should be equal to the first when there are no selections (ie. the Total). And a third line that compares the first two lines.

This is easily accomplished for normal expression that just require a sum(ALL variable) expression. Where I'm running into trouble is the formulas for the first row that already have set modifiers in them.

Here is an example of one such expression from the first row:

sum({$<CompleteAppts={0}>} PanelSize)/sum(PanelSize)

I tried using:

sum(ALL {$<CompleteAppts={0}>} PanelSize)/sum(ALL PanelSize)

But when you use a selection then the expression becomes filtered. How can I change the syntax so the Total version is not affected by the selections?

Thanks!

Excluding selections for expression with set modifiers

Wed, 01 Feb 2012 21:50:00 GMT

instead of using ALL use the dimension name itself .....

sum({$<CompleteAppts={0}, Dim1=, Dim2=>} PanelSize)/sum({<Dim1=,Dim2=>}PanelSize)

which means ignore whatever is selected in Dim1 and Dim2.

Excluding selections for expression with set modifiers

swuehl — Wed, 01 Feb 2012 21:54:26 GMT

Not sure if I understand, shouldn't the first row change with selections?

Maybe try using the set identifier {1} instead of $ for current selections:

sum({1<CompleteAppts={0}>} PanelSize)/sum( {1} PanelSize)