16 Replies Latest reply: Feb 13, 2018 5:44 PM by Nathan Parmeswar RSS

    If value is zero, show previous non-zero value

    Nathan Parmeswar

      Hello,

       

      I am new to Qlik Sense and I would like to know how to mentioned in the UI layer (not the script) to assign a previous value if a given measure is equal to zero.

       

      In this example, We have date as a dimension and price as a measure, if list price is equal to zero for a given finalized date, we want the price to be the price of the last non-zero price.

       

      This is what is shows right now

      Capture.PNG

      This is what I want it to show.

      Capture1.PNG

       

      is there any way we can do this for all cases like this?