Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.