topic Re: Total sum wont come after applying the expression! in QlikView

Total sum wont come after applying the expression!

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Dear guys,

I need to get the sum by applying the formula given below. Can someone to suggest me where I should modify this expression. What I simply need is to if the Actual is greater than the budget, for the all stated telephone numbers for the stated Months, to calculate the amount to be recovered. I get the exact output but the issue is it wont get the sum in the row. I may attach the related pivot table for your reference as well.

IF(Actual>BUDGET,SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},Month={'January','February','March','Ápril','May','June'}>}(Actual-BUDGET*1)),0)

Neville

Re: Total sum wont come after applying the expression!

nevilledhamsiri — Sat, 16 Sep 2017 17:20:48 GMT

Can some one please help me on this!. This is a urgent case!

Regards!

Neville

Re: Total sum wont come after applying the expression!

Neymar_Jr — Sat, 16 Sep 2017 17:40:03 GMT

Hi,

Can you please share a sample app or sample data?

Thank you!

Re: Total sum wont come after applying the expression!

swuehl — Sat, 16 Sep 2017 17:53:55 GMT

Maybe

SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},Month={'January','February','March','Ápril','May','June'}>}

IF(Actual>BUDGET,(Actual-BUDGET*1),0)

)

Use Aggregation Functions!

Re: Total sum wont come after applying the expression!

its_anandrjs — Sun, 17 Sep 2017 06:11:26 GMT

Or may be try this one need to know where using expression

=IF(Sum( TOTAL Actual) > Sum( TOTAL BUDGET), SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},

Month={'January','February','March','Ápril','May','June'}>}(Actual-BUDGET*1)),0)

SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},Month={'January','February','March','Ápril','May','June'}>}

IF(Actual>BUDGET,(Actual-BUDGET*1),0)

)