Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamically define first date for Master calendar

Hi,

How can define dynamically first date for Master calendar?

Thanks,

5 Replies
marcel_olmo
Partner Ambassador
Partner Ambassador

What do you mean with first date?

First selected? First sorted? Last value? Maximum date possible?

Regards, Marcel.

Not applicable
Author

Like this?

Temp_Calendar_Range:

LOAD

  Num(Date#(Min(MyDate), 'YYYYMM')) as MinDate

Resident [Main Data];

LET vMinDate = Peek('MinDate', 0, 'Temp_Calendar_Range');

DROP Table Temp_Calendar_Range;

Anonymous
Not applicable
Author

Please see my attached file.

I want to make calendar, where I can select any time frame.

Thanks,

Not applicable
Author

You mean to say Fiscal year calendar ?

Anonymous
Not applicable
Author

No, regular year