Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Edytagra
Contributor II
Contributor II

Issues with min date in master calendar

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

Edytagra_0-1599745194246.png

 

 

Labels (2)
0 Replies