4 Replies Latest reply: Dec 12, 2017 3:56 PM by Gonzalo Yagüe Suñol RSS

    Variable X scale on a combo chart (Qlik Sense)

    Gonzalo Yagüe Suñol

      Dear all,

       

      On the one hand, I have a combo chart displaying Sales and Forecast (measures) for each Week (dimension). Week is an integer ranging from 1 to 40. Sales are visualised as a bar chart and Forecast as a line chart. On the other hand, I have a filter with the number of Weeks.


      Firstly, I have to display Forecast  from 1st to 40th week regardless which week is selected on the filter. I have achieved it by typing the following code: Sum({1}Forecast). Secondly, I need to display Sales from the  first week to the maximum value selected on the filter. For example, if I selected either fourth and fith week or just fifth week, Sales should be displayed only for first, second, third, fourth and fifth week.

       

      I would really appreciate if anyone could help me solve this issue. Thank you very much in advance.

       

      Best regards,

       

      Gonzalo