Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Obtaining Min and Max Dates from month and year listboxes

Morning guys

If I have two list boxes, one each for "Year" and "Month", how would I write an expression that would return either the min or max dates of my selection combination.

I.e if I have 2016, and January selected, how would I return 01/01/2016 and 31/01/2016?

Many thanks,

Gareth

11 Replies
Kushal_Chawda

then use below, in two variable

MinVariable

=monthstart(floor(date#(max(Year)&max(Month),'YYYYMMM')))


MaxVariable

=monthend(floor(date#(max(Year)&max(Month),'YYYYMMM')))

Anonymous
Not applicable
Author

Sorry to be a pain, but how would I write an expression using these to count the dates in a field that fall between the range specified (using these two expressions)?