# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
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.

 TEAM WIN LOST Grand Total 389 206 PAKISTAN 50 21 INDIA 44 32 BANGLADESH 22 46 SRI LANKA 55 29 AUSTRALIA 77 19 NEW ZEALAND 59 26 SOUTH AFRICA 82 33 TEAM WIN LOST Grand Total 218 78 SOUTH AFRICA 82 33 AUSTRALIA 77 19 NEW ZEALAND 59 26
Tags (1)
20 Replies
MVP

## 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.

MVP

## 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.

MVP

## Re: Problem in display grand total of top n teams

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

MVP

## 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.

MVP

## Re: Problem in display grand total of  top n teams

Expression for each of the tables?