1 Reply Latest reply: Apr 14, 2016 7:24 AM by Stefan Wühl RSS

    Bounded time range for specific visualization

    Tal Sibony

      I loaded data to Qlik Sense that contains few different columns, 1 of them is date, and another is sales.

      I would like to create line chart for those parameters that contains only part of the total time range, how can i do that?

        • Re: Bounded time range for specific visualization
          Stefan Wühl

          In general you can limit the dimension value to a specific values either by using a calculated dimension or set analysis in all your expressions:

           

          1) Calculated dimension in dimension tab instead of the field dimension

           

          =If(Subject = 'English', Subject)

           

          or

           

          2) Set Analysis

           

          Something like

           

          =Avg( {<Subject = {'English'}>} Score)

           

          in all your aggregation functions.

           

          Hope this helps,

          Stefan