How to get the data greater than 500 and not equal to zero in Qliksense Table

[varaprasad0816]

Hi,

I have created a table in Qliksense with dimension and measures.

i need to get the data in one column (measure) like greater than or equal to 500 (CaseLoad >= 500)with below expression.

Sum({<CaseLoad={">=500"}>}CaseLoad) which is working fine but we are getting zero values as well.

We need to remove these zero values. Could you please let us know how to get the data greater than or equal to 500 and not equal to zero values.

It would be great helpful for me, if anyone can help me out on this.

Regards,

Vara

[lironbaram]

hi 

do you mean you want to remove the entire lines where this particular expression return zero 

if so you can try to use calculated dimension like this 

aggr(if(Sum({<CaseLoad={">=500"}>}CaseLoad) >0,Name),Name)

instead of your Name dimension  

[varaprasad0816]

Hi,
I have 4 dimensions like, IMS ID name, City, Region and State
So shall I write above calculated dimension in above mentioned all
dimensions ?

Regards,
Vara

[lironbaram]

hi 

if i understand your hierarchy than you don't need 

go with the calculated dimension only on name as it's the lowest level in the hierarchy