Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be you missed picture / image?
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:
My post will also kick things back up, so someone else may see things and have a better answer too.
Regards,
Brett