3 Replies Latest reply: Mar 5, 2018 1:38 AM by Kevin Alvino RSS

    How to get the Dimension values when there is no data for it in the Table(Zero values)

    Lakshman S

      Hi Experts,

       

      I want to display the year values regardless of having values for them in the excel sheet.

      I have the formulae like this in the graph to calculate a measure:

       

      Count({<A={'MissTime'},Season={'Preseason'},B={'Conditioning'}>}misstime_new)


      In Graph, i have Year and this measure. Now when i apply filter on Team. The graph shows data only for 2015 data which is actually correct. But the business users want to see the data even for 2016 and 2017. Is there a way to achieve this in qlik sense?


      Thanks,

      Lakshman