2 Replies Latest reply: Oct 24, 2016 4:56 PM by laurens pieters RSS

    Using min (or max) with Greater Than in Set Analysis

    laurens pieters

      Hi all,

       

      My first post in the qlik community so please forgive me if I'm doing something wrong. (I did search prior to adding this topic)

       

      So, my expression is correct until I try to 'inject' my MIN(date)

       

      My 'FirstDayMonth' contains the first day of the month of the 5 months in our reporting

      1/06/2016

      1/07/2016

      1/08/2016

      1/09/2016

      1/10/2016

       

      Because I want to keep it dynamic, I want to use the MIN function for the date.

       

      My expression:

      Sum({<DimMaterialType={"NB"}, [Contract Start Date]={'$(>=Min(FirstDayMonth))'} >} [Fees at CR])

       

      The problem should be with the bold italic part (>=)

       

      Thanks so much in advance helping me out!