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

    show 0 on chart qlik sense

    Joanna Seldon

      Hi

       

      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