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.

[MK_QSL]

attachment is missing

[ashfaq_haseeb]

Hi,

There is no attachment.

Regards

ASHFAQ

[#4]

Hi guys.

Thank you for your responses. Yes, I often have the issue of not being able to see the advanced editor on the top right when I click on "Reply."

Let me try again and look at my settings, unless if you know if there's an option to adjust?

Thank you.

[#5]

[ashfaq_haseeb]

Hi,

Try with different browser or contact Community manager.

Regards

ASHFAQ

[#7]

Thanks, I've tried, awaiting a response from someone.

If you have an alternate way that you could accept the file, please let me know.

Thank you.

[ashfaq_haseeb]

Hi,

You can upload files to Google drive or Drop box and share link here.

As I see you have problem with multiple dates.

Check the below post might help you.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/25/which-conditional-functions-do-you-use

Regards

ASHFAQ

[#9]

Hi everyone.

I've managed to get the dates qvw attached for now. Badically my issue is that many of my dates that satisfy met set analysis is not being flagged for counting.

Please can you assist me.

Thank you.

[#10]

Apologies, it showed as attached but alas, it does not show on refresh!