How to eliminate zero in the Graph

[Anonymous]

Hollo Everybody,  I am using QlikSense Desktop version and i am facing a problem while developing an APP.. I would like to omit zero part of the graph to have a better  view and to see the min values and the avg values correctly, i do not want to insert a condition in the SQL part, and i did check the option "remove zero or remove null value " on the properties part, it worked for the graph only , not for the MIn and AVG,
is there any way to remove the zeros and see the effect in the graph as well as in the labels MIN and AVG ?

P:S.. you can see the scripting or the fileds assigned for each part on the picture in red colour

[YoussefBelloum]

Hi,

uncheck "show nulls" option and check "suppress zero values" option

[OmarBenSalem]

Under adds-on, uncheck show Zero values

[Anonymous]

Thank you for your answer,
In which part or graph i shoud unchek null and then check surpress?

would you please provide me a screenshot of how to do that ?
by the way the is no option for null option in line chart, i had to add bar chart first and uncheck the null and then convert the chart to line chart .

[Anonymous]

I did that , it only workes for the chart not for the Min and Avg computations

[YoussefBelloum]

My sense Cloud are in French so just search these options on the right panel (the properties of the chart).

[YoussefBelloum]

if you're talking about the avg and the min objects on the right of the screen shot, you will need to add an aggregation to aggregate that min and that avg on a specific dimension.

[OmarBenSalem]

I see:

try something like: (alter it to ur need)

sum({<YourDim={"=sum({1}YourMeasure)>0"}>}YourMeasure)

[Anonymous]

dude , would you provide me an example for Min and avg , how to aggregate starting from a specific date ?
i have read every post in the community, no luck!

[Anonymous]

i want to omit the zero values from the begining ! if i uncheck the null , every null value will be removed ! while i do not want that because i want to consider the weekends , i only want to omit the begining