topic ignore zero values when considering smallest values in dimension limits in qlikview in QlikView

ignore zero values when considering smallest values in dimension limits in qlikview

anuradhaa — Thu, 22 May 2014 14:46:26 GMT

Hi,

In my data set i have zero values, i want to display smallest 15 average. in that list there may be zero values.

I want to ignore them and display smallest values exclude zeros. i have checked dimension limits, but it is not working.

Please help me.

Thanks

Thu, 22 May 2014 15:44:49 GMT

hi,

Not sure what u mean by smallest 15 avg. But if u want to display the smallest value ignoring zeros then try using the set:

e.g: =min({<val-={0}>}val)

where val can be 3,4,5,0,0,0 ,etc

in the above case the result will be 3 and not 0.

Please let me know if this helps.

SunilChauhan — Thu, 22 May 2014 15:57:14 GMT

presentation of chart-> supress zero values

hope this helps

anuradhaa — Fri, 23 May 2014 03:31:45 GMT

Hi when i select supress Zero values ,

when i select show smallest 15 values and my data set has 10 zeros, it only display 5 values in the bar chart.

Thanks,

Fri, 23 May 2014 04:53:03 GMT

Hi,

In the script, once again resident load the field whatever you are using in your expression, and give where condition as:

load

resident .......

where <your field name> <>0;

hope it will work.

Ananth