topic Re: Using min (or max) with Greater Than in Set Analysis in QlikView

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

Sun, 23 Oct 2016 21:06:00 GMT

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!

sunny_talwar — Mon, 24 Oct 2016 06:08:03 GMT

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])

Mon, 24 Oct 2016 20:56:49 GMT

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