Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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])
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])
Thank you Sunny T ! That syntax... something to get used to