topic TOTAL in Straight table differs in QlikView

TOTAL in Straight table differs

Thu, 28 May 2015 15:51:11 GMT

Hi Team,

I created a straight table, which shows only top 10 records using Presentation tab. In the TOTAL, it is summing up all the rows instead of only 10 recodrs. How to overcome this issue?

Re: TOTAL in Straight table differs

swuehl — Thu, 28 May 2015 16:19:51 GMT

Instead of the option in the presentation tab (which version of QV are you using btw?), you can limit the lines shown by a set expression.

Example:

Dimension: Salesrep

Expression: =sum({<Salesrep = {"=rank(sum(Sales))<=10"}>} Sales)

Now the total should be correct.

Re: TOTAL in Straight table differs

Thu, 28 May 2015 16:26:07 GMT

Hi,

Please try like in attached QVW file.

Regards,

Uday.

Re: TOTAL in Straight table differs

sasiparupudi1 — Thu, 28 May 2015 17:30:10 GMT

Please Uncheck "Show Others" tick box under options on the dimension limits tab.

Hope this helps

Regards

Sasi