7 Replies Latest reply: Oct 26, 2015 5:37 AM by Alex Bjølig RSS

    Get Max and Min values from 4 weeks period

    Alex Bjølig

      Hi Qlik Community.

       

      I have this following issue, i need to save max and min values in variables:

       

      1. The User selects a week (week 17)
      2. The table sums sales for the last 4 weeks (week 13- week 17)
      3. How do I get the MAX and MIN values from this list(marked with red)?

       

      I have attached screenshot and document to clarify.

       

      (If you are interested the end goal is to use the information to axis dimensions in a chart).

       

      Thanks many times in advance.

       

      Question 4 max and min.PNG