Total sum

rolandg1881 — Sat, 16 Nov 2024 18:42:09 GMT

Hi!

I have a problem and i hope somebody can help me.

I have the following formular in my Qlikview Pivot Table

sum(ZBU_Soll_Zeit)/(count({<[ZBU_Buchungsart]={'Normalbuchung'}>}[ZBU_BeginnBuchungsdatum]))

If i use sum(ZBU_Soll_Zeit) i got the total sum in the last row! Thats perfect!

But with the formula below there is no total sum.

How can i resolve this problem? Is it possible to make a total sum for:

sum(ZBU_Soll_Zeit)/(count({<[ZBU_Buchungsart]={'Normalbuchung'}>}[ZBU_BeginnBuchungsdatum]))

Thank you for your help!

Kind regards

Roland

Re: Total sum

rubenmarin — Mon, 04 May 2020 09:55:43 GMT

Hi, I don't see why it shouldn't work. If you set and expression with count({<[ZBU_Buchungsart]={'Normalbuchung'}>}[ZBU_BeginnBuchungsdatum]) works?

Double check field names and values, in particular upper/lower case of 'Normalbuchung'.

Also you can select 'Normalbuchung' on [ZBU_Buchungsart] field to confirm that there is data for that filter.

topic Re: Total sum in QlikView

Total sum

Re: Total sum