Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
MVP
MVP

Re: Find missing dates

I am not sure what you mean by "missing dates". Your script will populate the calendar with all possible dates between the min and the max dates, so there are no "missing dates" in the normal sense of the phrase.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Partner
Partner

Re: Find missing dates

Missing dates are the ones which has no Field value ie Funds

Highlighted
MVP
MVP

Re: Find missing dates

Then you can adapts Sunny's expression. Something like

Count(Distinct DATE) - Count({<Funds = {'*'}>} Distinct DATE)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor III
Contributor III

Re: Find missing dates

please find attachments.

Regards

sahadev

Highlighted
Contributor III
Contributor III

Re: Find missing dates

In Help.qvf i have count missing dates

using Following Expression

       "count(if(IsNull(Value),Date))"

Its work Fine

Regards

Sahdev