topic Re: Formula Question in QlikView

Formula Question

Wed, 04 Mar 2015 20:58:27 GMT

I am having issue with a formula not returning the expected value.

Here is my formula:

=if(Status <> 'Discarded', (sum({<Scenario={"2015 LBE"}>}(Amount * Division_Rate)/1000)),0).

The returned value is not excluding the 'Discarded' values from the sum.

sunny_talwar — Thu, 05 Mar 2015 02:19:34 GMT

Try if this works:

Sum({<Scenario = {'2015 LBE'}, Status = e({<Status = {'Discarded'}>})>} (Amount * Divison_Rate)/1000)

Best,

Thu, 05 Mar 2015 03:32:37 GMT

Hi Scott

Please check this formula.

sum({$<Senario={'2015LBE'}>-<Status={'Discarded'}>}Amount*Divison_Rate)/1000.

Regards

Harshana

renjithpl — Thu, 05 Mar 2015 04:34:21 GMT

Try this

=if(Status <> 'Discarded', (sum({<Scenario={'2015 LBE'}>}(Amount *Divison_Rate)/1000)), 0)

PrashantSangle — Thu, 05 Mar 2015 04:40:06 GMT

Hi,

Try like

sum({<Scenario={"2015 LBE"},Status -={"Discarded"}>}(Amount * Division_Rate)/1000)

It will give you red error line after -= but it will work for you

Regards

jagan — Thu, 05 Mar 2015 09:09:02 GMT

Hi,

Try like this

=sum({<Scenario={"2015 LBE"}, Status -={'Discarded'}>}(Amount * Division_Rate)/1000)

Note: Qlikview will show the above expression as error but it works.

Regards,

Jagan.

Thu, 05 Mar 2015 15:07:37 GMT

Thank you everyone this worked.