Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Effect of restricting dimension on totals in expressions

Does restricting the dimensions affects sum ( total ...) in expressions?

I am restricting my dimensions on rank (aggregate function) and then calculating total in expressions.

I am not getting true values.

Any ideas from anyone would be appreciated.

2 Replies
Gysbert_Wassenaar

Yes it does. Expressions calculate results based on the values of the dimensions shown in your chart. Perhaps you can use a variable or set analysis expressions. Can you post an example document that explains what you're trying to do?


talk is cheap, supply exceeds demand
Not applicable
Author

Here, Dim 1 is my calculated dimension (restricted by rank).

i want to see sum of sales in first expressions according to Dim 2 values e.g. sum of sales of A, B, C and so on in respective rows and in second expression, i want to see sum of sales according to Dim 1 values i.e. sum of sales of 1, 2 etc respectively. In second expression i want result irrespective of Dim 2 values.

Capture.PNG.png

i am getting issues while calculating expression 2.