Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.