Total Value problem

rolandg1881 — Sat, 16 Nov 2024 01:46:06 GMT

Hi everybody!

Perhaps anybody can help me before i got crazy. 😉

I have the following query for my Qlik Report the Data i got from our Database and its necessary to use crosstable.

"Costs
Crosstable (BABMonth,BABValue,7)
LOAD
Kostenstelle AS BAB_Kstelle_Id,
KostenartId AS BAB_Kart_Id,
name AS BAB_Kart_Name,
Kostenart AS BAB_PlanIstArtName,
if(name = '(Plfix)',s1,0) AS Test,
erfassdatum AS BAB_Datum,
gJahr AS BAB_Jahr,
s1 AS Juni,
s2 AS Juli,
s3 AS August,
s4 AS September,
s5 AS Oktober,
s6 AS November,
s7 AS Dezember,
s8 AS Jänner,
s9 AS Februar,
s10 AS März,
s11 AS April,
s12 AS Mai;"

when i make a diagram/table in Qlik i have the problem that the total values of the individual accounts are correct but the total above the accounts is not correct.

The formula for the total looks like that

"Sum({<[BAB_PlanIstArtName]={'Costs'}>}[BABWert])" for the actually costs

"Sum({<[BAB_PlanIstArtName]={'Planosts'}>}[BABWert])" for the planned costs (budget)

Does anybody know what the could be the problem?

I show it on the picture.

Re: Total Value problem

Anil_Babu_Samineni — Thu, 05 Dec 2019 11:23:45 GMT

May be you missed picture / image?

Re: Total Value problem

Brett_Bleess — Mon, 16 Dec 2019 20:43:51 GMT

Since you are using a Pivot Table, the only thing of which I can think is the following Help link, hopefully that may be what you need on this one:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm

My post will also kick things back up, so someone else may see things and have a better answer too.

Regards,
Brett

topic Re: Total Value problem in QlikView

Total Value problem

Re: Total Value problem

Re: Total Value problem