Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Tags (1)
20 Replies

Re: Problem in display grand total of top n teams

Is that second table is club to first table? and Please let us know your intend with sample qvw..

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: Problem in display grand total of  top n teams

The 2nd table is extracted from original table by using the vCounter variable (having value 0 to 7 where 0 means all team) in Max number(1 - 100) under presentation tab.

Re: Problem in display grand total of  top n teams

True, That is showing in your original post. But, What you are needed?

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: Problem in display grand total of  top n teams

The problem is with my grand total whether the value of vCounter is 0 or any other number upto 7, the grand total always shows win 389 lost 206 while it should be varied, lets see the 2nd table the grand total in QV for win is 389 and lost 206 ignoring the selection of vCounter value while if I select top 3 i.e., value of vCounter =3 then grand total should be win 218 and lost 78 which is correct.

Not applicable

Re: Problem in display grand total of  top n teams

The problem is with my grand total whether the value of vCounter is 0 or any other number upto 7, the grand total always shows win 389 lost 206 while it should be varied, lets see the 2nd table the grand total in QV for win is 389 and lost 206 ignoring the selection of vCounter value while if I select top 3 i.e., value of vCounter =3 then grand total should be win 218 and lost 78 which is correct.

Re: Problem in display grand total of top n teams

What are your expressions? Are you using dimension limits for your second table?

Re: Problem in display grand total of top n teams

I am guessing, you have done Dimension limits for Top table. Can you share file to test

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: Problem in display grand total of  top n teams

No I am not using dimension limit, as I have told you that I have used variable with name vCounter with initial value set to 0and in presentation tab you can see the Max Number having value 1 - 100 by default in Max Number, I have used that variable instead of fixed values.

Re: Problem in display grand total of  top n teams

Expression for each of the tables?

Community Browser