Doubt about one expression with dates.

[#1]

Hi. I hope this will be my last question today .

I have to make a graphic of payed dates / not payed dates divided by months.

I have a lot of Properties, and they have billing dates.

If i dont have billing date is that the client didnt pay the money.

For example. The client didnt pay in 5 months.

What do you think i should do? Thank you!

[Colin-Albert]

This post by Henric Cronström about reporting against Missing Data should help.

http://community.qlik.com/docs/DOC-3786

Have a look at the section "Populating a sparsely populated field"

Common cases are conversion rates and warehouse balances where only the dates with changing numbers can be found in the data. In both these cases, you often want to ask the question: “What was the status on this specific day?”
In other words, you want to click on a reference date to see the number that is associated with this
date – but the date might not exist in the data.

[hic · Accepted solution]

See also How to populate a sparsely populated field which is a short description of the same algorithm.

HIC