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: 
dnowebdn
Contributor
Contributor

autogenerate to load even if there is no data

Hi,

I have an app which i need to create a calendar object where i am using auto generate based on date key feild;

it works fine and application relaods succesfully if the date key feild is not empty however my case is that sometimes this date key feild would be empty  even though this feild is empty my application which is having auto generate based on this date key feild..

should not fail and dashboard should reload success.

Ideally i need to write lile - if datekey feild > 0 then autogenereate (days) or else autogenerate (0) which is proper number and makes dashboard successfi; reload

could some one help me out

2 Replies
sasiparupudi1
Master III
Master III

there is no need for your calendar to be dependent on your fact dates.

Perhaps, keep the minimum date from your fact date field but maximum can be today or 1 year in future or whichever your use case may be

tamilarasu
Champion
Champion

Hello,

Try this,

LET NumOfDays = Alt(End - Start + 1,0);


If you want to use "if" condition, you have to write like this.


LET NumOfDays = If(Not isnull(End - Start + 1), End - Start + 1, 0);