Difference from 2 columns in horizontal straight table

[bartvanwetten]

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.

[Clever_Anjos]

Use this show totals but suppress values in pivot table aproach by stalwar1

[bartvanwetten]

Hi Clever,

thanks for the reply but that gives me totals, not the difference.

But again, thx for the reply.

Bart

[sunny_talwar · Accepted solution]

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)

) )

[bartvanwetten]

Sunny T,

you made my day...AGAIN!

Regards,

Bart

[Clever_Anjos]

Just change the Total Expression to be a difference one