Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in display grand total of top n teams

These are two tables. In first one all teams all included, while in 2nd table top 3 teams w.r.t. highest win are included. My problem is that I am unable to display the grand total of 2nd table as 218 and 78. How can I display the grand total as I have tried under expression tab to how the sum of number of rows only not the expression total but it does not work.

    

TEAMWINLOST
Grand Total389206
PAKISTAN5021
INDIA4432
BANGLADESH2246
SRI LANKA5529
AUSTRALIA7719
NEW ZEALAND5926
SOUTH AFRICA8233
TEAMWINLOST
Grand Total21878
SOUTH AFRICA8233
AUSTRALIA7719
NEW ZEALAND5926
20 Replies
Not applicable
Author

What is the function 1 in the above expression?