4 Replies Latest reply: Oct 16, 2017 2:39 AM by ruti t RSS

    Missing Period in Chart - QlikSnese

    ruti t

      Hi,

       

      I Create line chart with 2 dims (Quarter and area) and 1 measure .

      I had a filter in the measure that will display the last 3 quarter:

      count({$<Quarter={'$(=$(V_Max_1_Q))','$(=$(V_Max_2_Q))','$(=$(V_Max_3_Q))'}>}Tests)

       

      I want that the chart will display always 3 quarters even there is no data in one of the quarter (display with value 0 ). Currently, it shows only the quarters with data (attach example).

       

      Any Idea?

       

      Thank you!