Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Excluding selections for expression with set modifiers

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!

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Excluding selections for expression with set modifiers

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)

2 Replies
Not applicable

Excluding selections for expression with set modifiers

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.

MVP
MVP

Excluding selections for expression with set modifiers

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)

Community Browser