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:
Load
min(DATA) as minDate,
max(DATA) as maxDate
Resident 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