topic Re: autogenerate to load even if there is no data in QlikView

autogenerate to load even if there is no data

dnowebdn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: autogenerate to load even if there is no data

sasiparupudi1 — Thu, 19 Apr 2018 18:14:35 GMT

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

Re: autogenerate to load even if there is no data

tamilarasu — Thu, 19 Apr 2018 18:44:10 GMT

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);