Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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