Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

oseimuduame
Contributor

Defined Expressions

Good Morning,

I have a table where i want to display only items that meet my Expresion Definition

thresh.PNG

I have the above table and i would like to see only items that meet my definition. Below is my Formula;

If(Price < 150000, Sum(Price))

Any Help Please

14 Replies

Re: Defined Expressions

Try this

Sum({<Price = {'< 150000'}>}Price)

Re: Defined Expressions

Also, make sure that 'Suppress Zero Value' is checked on the presentation tab of the chart properties

oseimuduame
Contributor

Re: Defined Expressions

I have done that and its working.

But i still have a further Issue is that i can do for one Condition how do i add additional condition for another table.

E.G i want to calculate for > 150000 < 300000.

Using Sum({<Price = {'>150000','<300000'}>}Price) i am getting all even the one that satisfy the first condition

Note Different Condition for Different Table

Any Help

Re: Defined Expressions

Try this

Sum({<Price = {'>150000<300000'}>} Price)

oseimuduame
Contributor

Re: Defined Expressions

Thank You Very Much this works well now

Can i have your personal email so we can talk better. I am currently the Senior B.I Developer for my company and i would like Learn from you my friend.

So far so good i have 25 dashboards that are working very fine.

Thank You

oseimuduame
Contributor

Re: Defined Expressions

i am a little bit confused. I just sorted this outcome now and i find out  this;thresh2.PNG

For the first Condition (<150000, it still shows all the Prices.

Re: Defined Expressions

Try this

If(Sum(Price) < 150000, Sum(Price))

oseimuduame
Contributor

Re: Defined Expressions

This works fine now thank You.

But how do i go about the other condition. i just set it up for the First and the last condition but i need the middle condition.

< 150000 = Bronze

>150000 and < 300000 = Silver

>300000 and <500000 = Golden

>500000 = Platnum


How do i achieve Silver and Golden

Re: Defined Expressions

May be this

If(Sum(Price) > 150000 and Sum(Price) < 300000, Sum(Price))

Community Browser