topic Re: Dates in my set in QlikView

Dates in my set

Thu, 15 May 2014 06:08:15 GMT

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.

Re: Dates in my set

MK_QSL — Thu, 15 May 2014 06:09:41 GMT

attachment is missing

Re: Dates in my set

ashfaq_haseeb — Thu, 15 May 2014 06:10:41 GMT

Hi,

There is no attachment.

Regards

ASHFAQ

Re: Dates in my set

Thu, 15 May 2014 06:14:54 GMT

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.

Re: Dates in my set

Thu, 15 May 2014 06:30:46 GMT

Re: Dates in my set

ashfaq_haseeb — Thu, 15 May 2014 06:34:28 GMT

Hi,

Try with different browser or contact Community manager.

Regards

ASHFAQ

Re: Dates in my set

Thu, 15 May 2014 10:44:14 GMT

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.

Re: Re: Dates in my set

ashfaq_haseeb — Thu, 15 May 2014 10:48:05 GMT

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

Re: Dates in my set

Wed, 21 May 2014 06:53:21 GMT

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.

Re: Dates in my set

Wed, 21 May 2014 06:55:11 GMT

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

Re: Re: Dates in my set

ashfaq_haseeb — Wed, 21 May 2014 07:06:31 GMT

Hi,

Please find the attachment.

Regards

ASHFAQ

Re: Re: Dates in my set

Wed, 21 May 2014 07:15:15 GMT

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!

Re: Dates in my set

Wed, 21 May 2014 11:10:10 GMT

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?

Re: Re: Re: Dates in my set

Wed, 21 May 2014 11:45:43 GMT

Hi.

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

Thank you.

Re: Re: Re: Re: Dates in my set

ashfaq_haseeb — Wed, 21 May 2014 12:00:42 GMT

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

Re: Re: Re: Re: Dates in my set

Thu, 22 May 2014 05:19:29 GMT

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.

Re: Dates in my set

Thu, 22 May 2014 08:56:06 GMT

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