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: 
linoyel
Specialist
Specialist

Qliksense derived fields calendar gaps

Hi, is there a way to fill in date gaps in autoCalendar?

14 Replies
Gysbert_Wassenaar

Ah, yes. In that case you want to use the third parameter of the CalendarFromField subroutine for at least of of the calendar tables so the field names get prefixed with the value used as the third parameter.


talk is cheap, supply exceeds demand
linoyel
Specialist
Specialist
Author

Cool!!! Thanks a lot!

linoyel
Specialist
Specialist
Author

Gysbert, is it possible to add fields to Qvc Calendar in the script?

I mean, it's not a table so I'm not able to perform a resident load from it and add fields...

Gysbert_Wassenaar

Yes, you can do that in at least two ways. You can specify an extension file where you defined your extra calendar fields. The default name of the file is CalendarExtSetVariables.qvs. (see line 115 in Qvc.qvs). You can override it if you want and use the variable  Qvc.Calendar.v.ExtFields to specify a different file. The file should reside in a folder you can specify that location in the variable Qvc.Global.Extension.Directory.

For example: SET Qvc.Global.Extension.Directory = qvs_extensions;

Of course you do need to make sure that folder exists and the script file with your extra fields lives there.

The other way is to do a resident load of the calendar that the Qvc.CalendarFromField call generates, then add the extra fields to it and drop the script generated calendar table.


talk is cheap, supply exceeds demand
linoyel
Specialist
Specialist
Author

Great, thanks again