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: 
ashmitp869
Creator II
Creator II

Calculate vminDate and MaxDate from user selected Year

Hi All,

I need to create variable : the min and max date  when any Reporting Date.Year is selected.

Say for example, when selecting Reporting Date.Year as 2021

The variable vMinDate should be min date of the Reporting Date.Year = 2021

and vMaxDate should be max date of the Reporting Date.Year = 2021

Regards

 

1 Reply
MayilVahanan

Hi @ashmitp869 

Try like below

vMinDate = Min(Date)

vMaxDate  = Max(Date)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.