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: 
Anonymous
Not applicable

Total in straight table for the first N records

Hey guys!

I would like to receive your expertise on the following problem:

I am creating straight table to calculate sum of sales (with descending order) with limited quantity of records (defined in the Presentation tab), but it seems, that  total in expression takes all records, not those, which are presented in result.

Is there any possibility to make total value reflecting only with visible records?

Expected result of total => 4 566

Thanks in advance!

1 Solution

Accepted Solutions
sunny_talwar

Use this expression instead of using the settings on the presentation tab

=If(Rank(TOTAL Sum(Sales)) < 6, Sum(Sales))

and also make sure to select "sum of rows" under Total Mode on the expressions tab

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Use this expression instead of using the settings on the presentation tab

=If(Rank(TOTAL Sum(Sales)) < 6, Sum(Sales))

and also make sure to select "sum of rows" under Total Mode on the expressions tab

Capture.PNG

Anonymous
Not applicable
Author

Thanks, man!!!!