topic Re: Grand total in QlikView

Grand total

Tue, 27 May 2014 03:18:05 GMT

Hi All,

I have a question if this is possible in the pivot chart. I have a table:

Type	Quantity		Revenue
Month	Jan-14	Feb-14	Jan-14	Feb-14
F1	Jan-14	Feb-14	Jan-14	Feb-14
A	100	200	350	100
B	150	300	120	230
C	500	200	700	650
Grand Total			1170	980

I only want to show the GRAND TOTAL for Revenue. Not in quantity. Is this possible?

Thanks,

Lyn

Re: Grand total

sujeetsingh — Tue, 27 May 2014 03:43:39 GMT

I dont think Grand totals are possible in Pivot . You can use some trick like using text boxes and

Re: Grand total

robert_mika — Tue, 27 May 2014 04:04:21 GMT

Try

tab Presentation ->Show Partial Sums

Re: Grand total

Tue, 27 May 2014 05:51:16 GMT

Yes, I know that you can show the partial sums. but the grand total for quantity will also be shown. I don't want to show that. I only want to show the grand total for revenue.

Re: Re: Grand total

anbu1984 — Tue, 27 May 2014 06:00:55 GMT

Try this

Re: Grand total

albertovarela — Tue, 27 May 2014 06:04:21 GMT

Hello,

This trick might be helpful:

1. Right mouse click on top of the Subtotal you don't want

2. Select Custom Format Cell

3. Make the text color equal to the background color

Cheers,

Alberto

Re: Grand total

CELAMBARASAN — Tue, 27 May 2014 06:09:38 GMT

Assuming that you are using Sum(Quantity) as expression.

After enable the partial sum you will get grand total for both revenue and quantity

for quantity expression alone change it like this

If(RowNo() > 0, Sum(Quantity), '')

Hope it helps

Re: Grand total

dharmarasu — Tue, 27 May 2014 06:10:21 GMT

Hi lyn,

I think it is not possible in pivot table

but u can use Straight table and in the expression tab select No Total for which total u don't want to show..

Regards,

Dharma

Re: Grand total

Tue, 27 May 2014 06:15:12 GMT

This is what i'm looking for! Thank you!