Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an expression
=min(aggr(floor(sum({$<period = {">=$(=$(vPeriodSet_PY)*100+12)<=$(vEndPeriod_CY)"}-{"$(=$(vPeriodSet_PY)*100+13)"}
, Datasource = {'Actual'} >} GBP)+50000,100000)/1000000,period))
I want to exclude where the value is zero.
How would I do this?
Many thanks
Paul
Hi Gysbert
It's where the min is not zero.
Many thanks
Paul
Hi Gysbert
This is in Qlikview and the expression is being used in a reference line.
Hi Paul,
I also do not see the min. Nevertheless, to do a not equal to 0 in set analysis you go
count({<field ={'-=0'} >} value)
what you are looking for is {'-=0'} . Let me know if this helps you somehow with your logic.
Hi Thiago
Thanks for trying, but I cant seem to get it to work.
I'll take a bit more time myself
Thanks
Paul
also thanks Wilsonwebb
You've given me ideas ill see if I can it to work