Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Formula Question

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.

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Formula Question

Try if this works:

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

Best,

S

View solution in original post

6 Replies
Highlighted

Re: Formula Question

Try if this works:

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

Best,

S

View solution in original post

Highlighted
Not applicable

Re: Formula Question

Hi Scott

Please check this formula.

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

Regards

Harshana

Highlighted
Valued Contributor

Re: Formula Question

Try this

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

Highlighted

Re: Formula Question

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

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
MVP & Luminary
MVP & Luminary

Re: Formula Question

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.

Highlighted
Not applicable

Re: Formula Question

Thank you everyone this worked.