Multiple statement on expression

[khalid_msd]

Dear All ,

Is it possible to have multiple statement on express as given below . We need to reset different values before adding them.

if  (VSales= 0, WSales=0)

if (VDIncome= 0, WDIncome=0)

if (VCost= 0, WCost=0)

WSales+WDIncome+WCost

thanks ,

[JaMajka1]

Hi Khalid,

do you want to do it in load script or in expression in frontend?

BR,

Maria

[khalid_msd]

We need it in expression on front-end

[JaMajka1]

Hi Khalid,

try this expression with set analysis (you can find more about for example here https://help.qlik.com/en-US/sense/September2017/Content/Videos/Videos-set-analysis-introduction.htm😞

sum({$<VSales=-{'0'}>}WSales)+sum({$<VDIncome=-{'0'}>}WDIncome)+sum({$<VCost=-{'0'}>}WCost)

Hope it helps .

BR,

Maria