Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

QlikView

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!

Who Me Too'd this solution

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

Who Me Too'd this solution