14 Replies Latest reply: May 17, 2018 8:45 AM by Youssef Belloum RSS

    How to eliminate zero in the Graph

    Moslem Teymoori

      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

       

       

       

       

      2018-05-17_10h42_26.jpg