Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
can you help me out on this challenge. Attached is a QlikView document with a horzizontal straight table. Now column 3 should show the difference between the 1st and second but I can't get it right.
The correct numbers are in the excel screendump, shown in a text object.
I know the datamodel is worse, but the customer begged me for a solution in the expressions of the graphs.
Thanks in advance you all.
Bart.
Try this:
if(RapportCat='Begroting',
sum({<PrognoseVersie={'$(vPrognoseVersie)'}>}Bedrijfskosten),
if(RapportCat='Verschil'
,
sum(TOTAL <RapportPeriode>{<RapportCat = {'Resultaat', 'Prognose'}>}Bedrijfskosten)
+
sum({<PrognoseVersie={'$(vPrognoseVersie)'}>}Bedrijfskosten)
,
sum(Bedrijfskosten)
) )
Use this show totals but suppress values in pivot table aproach by stalwar1
Hi Clever,
thanks for the reply but that gives me totals, not the difference.
But again, thx for the reply.
Bart
Try this:
if(RapportCat='Begroting',
sum({<PrognoseVersie={'$(vPrognoseVersie)'}>}Bedrijfskosten),
if(RapportCat='Verschil'
,
sum(TOTAL <RapportPeriode>{<RapportCat = {'Resultaat', 'Prognose'}>}Bedrijfskosten)
+
sum({<PrognoseVersie={'$(vPrognoseVersie)'}>}Bedrijfskosten)
,
sum(Bedrijfskosten)
) )
Sunny T,
you made my day...AGAIN!
Regards,
Bart
Just change the Total Expression to be a difference one