topic Re: Pivottable Totals in QlikView

Pivottable Totals

MBV — Sat, 16 Nov 2024 00:05:41 GMT

Hey Guys!

I've got a Problem with my pivottable.

There is data until YTD (ist) and for the rest a forecast is calculated (prog).
Now I want to combine these columns (kombi).

The problem, as you can see, is that the total is not calculated correctly. Only the ist-valus are considered although the rows are correct.

Does anybody know a solution?

Thanks in advance!!

lironbaram — Mon, 24 Aug 2020 11:10:16 GMT

hi,

you need to do something like

sum(aggr(if(sum(ist)>0,sum(ist),sum(prog)),Monat,Elnkaufe...))

MBV — Mon, 24 Aug 2020 12:11:39 GMT

I'm already using Sum(Aggr()) in my expressions

Kushal_Chawda — Mon, 24 Aug 2020 13:12:11 GMT

What is the expression you are using?

Kushal_Chawda — Mon, 24 Aug 2020 13:49:01 GMT

try to add field in aggr which is used as column display in pivot

MBV — Tue, 25 Aug 2020 10:05:19 GMT

How would you adjust this Expression using Sum(Aggr())?

if(Sum({< Jahr={$(YTDYear)} >}[h/VK])= '0' ,

(Sum({< Jahr={$(VJ)} >}[h/VK])+ Sum({< Jahr={$(VVJ)} >}[h/VK])+ Sum({< Jahr={$(VVVJ)} >}[h/VK]))/3

,Sum({< Jahr={$(YTDYear)} >}[h/VK]))

Brett_Bleess — Tue, 08 Sep 2020 15:49:56 GMT

The following Design Blog post may be of help on this one:

@Kushal_Chawda If you want to have another look, the poster did post the expression...

Regards,
Brett

Kushal_Chawda — Tue, 08 Sep 2020 15:53:10 GMT

sum(aggr(if(Sum({< Jahr={$(YTDYear)} >}[h/VK])= '0' ,

(Sum({< Jahr={$(VJ)} >}[h/VK])+ Sum({< Jahr={$(VVJ)} >}[h/VK])+ Sum({< Jahr={$(VVVJ)} >}[h/VK]))/3

,Sum({< Jahr={$(YTDYear)} >}[h/VK])),

Monat,Elnkaufe))

Note: If you have other dimensions, add that as well in aggr function

MBV — Wed, 09 Sep 2020 08:03:12 GMT

It's working!! Thank you!