Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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