Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

How to display list of missing dates for a specified month in a text box

I want to be able to list any missing dates for a specified month in a text box.

i.e.

Object1 has some dates in July missing, so I want to be able to see a list of the dates that are missing in a text box.

Within my data, I haven't got values against those dates.

I have attached a sample data sheet and qvw.

Please if someone can help me with this.

Thank you.

Tags (1)
1 Solution

Accepted Solutions
robin_hausdoerfer
Valued Contributor III

Re: How to display list of missing dates for a specified month in a text box

try

concat(distinct {$<Date=E({< Rate={"*"} >}) >} Date  ,' | ',Date)

View solution in original post

3 Replies
robin_hausdoerfer
Valued Contributor III

Re: How to display list of missing dates for a specified month in a text box

try

concat(distinct {$<Date=E({< Rate={"*"} >}) >} Date  ,' | ',Date)

View solution in original post

Partner
Partner

Re: How to display list of missing dates for a specified month in a text box

Hi Robin,

This works, Thank you for the response.

how can we obtain these dates in a variable- Minimum date and the maximum date?

Thank you

robin_hausdoerfer
Valued Contributor III

Re: How to display list of missing dates for a specified month in a text box

min(distinct {$<Date=E({< Rate={"*"} >}) >} Date)

max(distinct {$<Date=E({< Rate={"*"} >}) >} Date)

???