Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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!

1 Solution

Accepted Solutions
sunny_talwar

There is couple of ways you can handle this:

Option 1:

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

Option 2:

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

View solution in original post

2 Replies
sunny_talwar

There is couple of ways you can handle this:

Option 1:

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

Option 2:

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

Not applicable
Author

Thank you Sunny T ! That syntax... something to get used to