topic Re: Compare Date with Variable Date in Set Analysis in QlikView

Compare Date with Variable Date in Set Analysis

Tue, 09 Apr 2013 01:49:04 GMT

Facing an issue with the below expression, could you help?

[Program Date] = {"<=Date($(vSelectedDate), 'dd/MM/yyyy')"}

Here variable vSelectedDate = 31 Jan 2013

regards,

Bobby

Re: Compare Date with Variable Date in Set Analysis

sushil353 — Tue, 09 Apr 2013 04:57:43 GMT

hi,

make sure that the data type and format of [Program Date] and vSelectedDate should be same..

try to see the format using test box : =vSelectedDate..

and then use in setanalysis as

[Program Date] = {"<=$(vSelectedDate)"}

also try this:

[Program Date] = {"<=date#($(vSelectedDate), 'dd/MM/yyyy'))"}

HTH

Sushil

Re: Compare Date with Variable Date in Set Analysis

kaushiknsolanki — Tue, 09 Apr 2013 05:51:23 GMT

Hi,

Have a look at your other post.

http://community.qlik.com/thread/79048?tstart=0

Regards,

Kaushik Solanki

Re: Compare Date with Variable Date in Set Analysis

Tue, 09 Apr 2013 05:57:07 GMT

HI ,

Please try the below code

[Program Date] = {'$(=date#(vSelectedDate, 'DD MMM YYYY'))'}

Please let me know if there is anything .

Re: Compare Date with Variable Date in Set Analysis

Tue, 09 Apr 2013 08:00:34 GMT

Hi Bobby,

Im assuming that [Program Date] is in the format dd/MM/YYYY?

You will have to convert vSelectedDate to this format using the following formula:

[Program Date] = {"<=Date(date#($(vSelectedDate), 'DD MMM YYYY'), 'dd/MM/yyyy')"}

Regards

Re: Compare Date with Variable Date in Set Analysis

Tue, 09 Apr 2013 08:00:38 GMT

Hi Bobby,

Im assuming that [Program Date] is in the format dd/MM/YYYY?

You will have to convert vSelectedDate to this format using the following formula:

[Program Date] = {"<=Date(date#($(vSelectedDate), 'DD MMM YYYY'), 'dd/MM/yyyy')"}

Regards

Re: Compare Date with Variable Date in Set Analysis

Tue, 09 Apr 2013 08:01:14 GMT

Hi Bobby,

Im assuming that [Program Date] is in the format dd/MM/YYYY?

You will have to convert vSelectedDate to this format using the following formula:

[Program Date] = {"<=Date(date#($(vSelectedDate), 'DD MMM YYYY'), 'dd/MM/yyyy')"}

Regards

Re: Compare Date with Variable Date in Set Analysis

Tue, 09 Apr 2013 08:01:27 GMT

Hi Bobby,

Im assuming that [Program Date] is in the format dd/MM/YYYY?

You will have to convert vSelectedDate to this format using the following formula:

[Program Date] = {"<=Date(date#($(vSelectedDate), 'DD MMM YYYY'), 'dd/MM/yyyy')"}

Regards

Re: Compare Date with Variable Date in Set Analysis

swuehl — Tue, 09 Apr 2013 10:07:57 GMT

If you need to interpret / parse your variable, you should use the date#() function and an appropriate format code:

Date#(vSelectedDate, 'DD MMM YYYY')

then maybe you need to use an additional Date() function to format your date according to [Program Date]'s format. Assume [Program Date] is formatted like 'MM/DD/YYYY':

Date(Date#(vSelectedDate, 'DD MMM YYYY'),'MM/DD/YYYY')

to execute an expression like above in a set analysis field modifer, you'll need to use a dollar sign expansion with expression:

[Program Date] = {"<=$(=Date(Date#(vSelectedDate, 'DD MMM YYYY'),'MM/DD/YYYY'))"}

Re: Compare Date with Variable Date in Set Analysis

Tue, 09 Apr 2013 10:37:17 GMT

Hi Bobby,

[Program Date]={"<=$(vSelectedDate)"}

vSelectedDate-> format this in a variable

Try this.

Regards,

Sukamal