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