expression total and excel total not tie up

[gauthamchilled]

In the attached qlikview, the variance and variance % total is not tie up with excel calculations. can any one help?

Regards,

Gautham

[gauthamchilled]

No, i think you are not getting it...please find the attached i am getting total value as 189. but expected is 42% only

Regards,

Gautham

[vinieme12]

use

(sum(Proforma)-sum(Existing))/sum(Existing)*100

or add Square brackets when referring to expression labels

([proforma]-[existing])/[existing]*100

[rong]

Gautham,

Change the total mode on your variance expression as shown below, this will fix the total percentage for your column.

[vinieme12]

gauthamchilled if your query is resolved please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful

[Anonymous]

Change your Variance % expression to

((column(2)-column(1))/column(1))*100

Some brackets were missing.