Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
andreyfcdk91
Creator
Creator

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

View solution in original post

andreyfcdk91
Creator
Creator
Author

Thanks, man!!!!