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

[anuradhaa]

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

[#2]

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]

presentation of chart-> supress zero values

hope this helps

[anuradhaa]

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,

[#5]

Hi,

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

load

     <your field name>

resident .......

where <your field name> <>0;

hope it will work.

Ananth