topic Re: Additional subtotal in straight table in QlikView

Additional subtotal in straight table

azimabadi — Fri, 01 Feb 2013 09:14:02 GMT

Hi,

I have a straight table that i show top 5 (using limits option in "Dimension Limits" in chart's properties and sum of others too.

At the bottom i get the total sum. But i need to demonstrate the data in straight table as follow:

Top 5

---------------------------------------

Sum of top 5

---------------------------------------

Others

---------------------------------------

Total sum

I appreciate any idea.

Best regards - peyman

er_mohit — Fri, 01 Feb 2013 09:30:34 GMT

hiii top 5

for sum of top 5

others

total sum

see the attached image

Gysbert_Wassenaar — Fri, 01 Feb 2013 10:03:38 GMT

The easiest solution is to use two overlapping straight charts. See attached qvw.

azimabadi — Fri, 01 Feb 2013 10:06:30 GMT

Thx mohit,

But i need "others" and total sum too.

This way i loose others.

Best regards-peyman