topic Re: Expression total error in getting delta in QlikView

Expression total error in getting delta

Wed, 25 Nov 2020 16:16:04 GMT

Expense

$192,577

($163,772)

Here ($163,772) is _ve value and when I give expression total in a straight table I get $356,349 which is wrong.I have to get the delta of 28,805.How can I achieve that ?

Thanks much

Re: Expression total error in getting delta

sunny_talwar — Mon, 28 Mar 2016 16:49:16 GMT

Try 'Sum of Rows' as total mode. If that doesn't work still, would you be able to share a sample?

Re: Expression total error in getting delta

amayuresh — Tue, 29 Mar 2016 06:40:13 GMT

Can you post sample data ?

Because it work for me in normal scenario,

Script:

LOAD * INLINE [

Category, Item, Supplier, Data

Cat1, Item11, Sup2, 100

Cat1, Item11, Sup3, -150

Cat1, Item12, Sup1, 200

Cat1, Item12, Sup2, 1

Cat1, Item12, Sup3, 1

Cat1, Item12, Sup4, 1

Cat2, Item21, Sup2, 1

Cat2, Item21, Sup3, 1

Cat2, Item21, Sup4, 1

Cat3, Item31, Sup1, 1

Cat3, Item31, Sup2, 1

Cat3, Item31, Sup3, 1

Cat3, Item31, Sup4, 1

Cat3, Item32, Sup1, 1

Cat3, Item32, Sup4, 1

];

Output:

Re: Expression total error in getting delta

tyagishaila — Tue, 29 Mar 2016 06:55:34 GMT

share sample data...

how you consider ($163,772) as -ve.

if your

Expense

$192,577

-$163,772

than you will definitely get correct total/Sum.

Re: Expression total error in getting delta

avinashelite — Tue, 29 Mar 2016 07:05:24 GMT

Try like this

if(wildmatch(Expense,'(*)')>0,purgechar(Expense,'()')*-1,Expense)

Re: Expression total error in getting delta

Anonymous — Tue, 29 Mar 2016 07:12:16 GMT

Once export your chart to excel and check .share your sample data