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



      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


      This is what I want it to show.



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