Dates in my set

[#1]

Hi everyone.

Often I seem to have issues with dates. Despite using makedate to force it to the format I need when rendering dates from external sources as well as date, date# etc, they do not always work. I would like to hopefully find a solution to this intermittent problem with your help and expertise please.

Attached is a sample model: the user selects a date and I check if that date equals to the Ben Event Registration Date. Though I can see they're the same and have tried many date formatting techniques, QlikView does not see them as being the same, therefore my set analysis does not count the records that it should.

Please could you help.

Thank you.

[ashfaq_haseeb]

Hi,

Please find the attachment.

Regards

ASHFAQ

[#3]

Thank you Ashfaq.

I cannot seem to see anything so I have raised it again with QlikView. Is the file called Dates2?

If so, that would be the one I require help with.

Thank you!

[#4]

Hi Ashfaq.

Apologies for all the web issues.

You solution works. My question is that $ if omitted is implied. Why would it be though that excluding it made the solution work?

[#5]

Hi.

When I tested more cases, I find it also to not work 100%. Please refer to comments on model.

Thank you.

[ashfaq_haseeb]

Hi

That is because,in your expression you wrote

  [Status Description] = {"Resigned"}

Whereas I checked in your application by dropping that field  [Status Description] and I just only find active.

Please look at the attachment.

Regards

ASHFAQ

[#7]

Hi Ashfaq.

When I created the temp model for uploading I forgot to comment out that line. This is why you are now able to obtain rows coming back. However the set analysis in each chart is either bringing other dates in addition to the correct ones, or none at at all even though many dates do indeed satisfy the criteria.

It works very intermittently which is why I'm uncertain as to what the issue is.

Thanks.

[#8 · Accepted solution]

I managed to find another document on set analysis this morning and basically there was an unnecessary equal to sign that caused the issue.