topic Re: Difference from 2 columns in horizontal straight table in QlikView

Difference from 2 columns in horizontal straight table

bartvanwetten — Mon, 30 May 2016 15:04:22 GMT

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.

Re: Difference from 2 columns in horizontal straight table

Clever_Anjos — Mon, 30 May 2016 15:10:22 GMT

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

Re: Difference from 2 columns in horizontal straight table

bartvanwetten — Mon, 30 May 2016 15:14:41 GMT

Hi Clever,

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

But again, thx for the reply.

Bart

Re: Difference from 2 columns in horizontal straight table

sunny_talwar — Mon, 30 May 2016 15:16:03 GMT

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)

) )

Re: Difference from 2 columns in horizontal straight table

bartvanwetten — Mon, 30 May 2016 15:19:54 GMT

Sunny T,

you made my day...AGAIN!

Regards,

Bart

Re: Difference from 2 columns in horizontal straight table

Clever_Anjos — Mon, 30 May 2016 15:20:58 GMT

Just change the Total Expression to be a difference one