Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey guys,
Im struggling with adding master calndar to my model in Qlik Sense.
I stuck with mindate. When Im checking min date in analysis dashboard i got a numer, however when i check date with function min(DATA) I got a date.
The date Ive created while loading script from seperate fields => MakeDate(year,month,day) as DATA
Then I started to create master calendar with the code:
Temp:Loadmin(DATA) as minDate,max(DATA) as maxDateResident ROZLICZENIE;
I got minDate as value. And when I run the code for master calndar I got an error that field'a' cannot be found.
Could you assist? Ill be very grateful.
Thanks in advance