Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Purple_13s
Contributor
Contributor

Find First Date and last date in month

Hello!

Many thanks in advance for your response... 

I have created a field 'Dates' which is the load date for each of my files.

I want to be able to extract the first load date and last load date from each month.

I then want to be able to store the first and last load dates as a variable to use in a set expression for charts + other kpis.

Purple_13s_1-1667557614998.png

 

 

Labels (1)
1 Reply
AndyC
Contributor III
Contributor III

Not sure exactly what you are trying to do but have you looked at the on-line help?

There are examples of using the Group By in the load script...

Max - script function ‒ Qlik Sense on Windows

Min - script function ‒ Qlik Sense on Windows