3 Replies Latest reply: Aug 30, 2017 9:18 AM by Joanna Seldon RSS

    show 0 on chart qlik sense

    Joanna Seldon



      using a weeks as a dimension  weekend(OrderDate)


      trend line chart


      MissedOrder column in the load is 1 or null



      i have in the set analysis measure as follows count( distinct {$<MissedOrder = {'1'}>} OrderID)


      this shows how missed orders have been processed every week...


      however i want to show the sometimes weeks that have no missed orders as 0 on the trend line 


      how do i do this please


      please help