Find missing dates

[qlik_aparna]

Hi

I have linked my date field with master calendar date field. Now I need to find the missing dates in my data using master calendar date

in an expression.

The expression for actual days is

Count(DISTINCT {<Field name>} DATE) which is giving correct results.

Now I want to find the count of missing dates for each field.

[jonathandienst]

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.

[qlik_aparna]

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

[jonathandienst]

Then you can adapts Sunny's expression. Something like

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

[Anonymous]

please find attachments.

Regards

sahadev

[Anonymous]

In Help.qvf i have count missing dates

using Following Expression

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

Its work Fine

Regards

Sahdev