topic Date to a variable in QlikView

Date to a variable

Tue, 08 Nov 2011 14:38:48 GMT

Hi,

I have three list box, for year, month and day.

If the user selects the date, I want to pass that to a variable as vPickDate. And then I want that vPickDate in chart expression. Like select data when vPickDate is greater than Planned Date.

How do I pass the selections made in day, month, and year to one variable and use that in chart.

I appreciate any help

Thanks

Date to a variable

jagan — Tue, 08 Nov 2011 14:58:08 GMT

Use the MakeDate() to generate date based on the Year, Month and Day.

Ex :vPickDate = MakeDate(Max(Year), Max(Month), Max(Day))

Regards,

Jagan.

Date to a variable

Tue, 08 Nov 2011 15:00:56 GMT

Great. Thanks for the reply Jagan

But I want to pass the current selection from the list box to the vPickDate.

How will that work?

Thanks!

Date to a variable

jagan — Tue, 08 Nov 2011 15:08:45 GMT

vPickDate = MakeDate(Max(Year), Max(Month), Max(Day))

Here Year, Month and Day are the list boxes.

Suppose if you select

Year - 2011

Month - 2

Day - 5

The Max(Year) will fetch 2011 similarly the other will do and by using the MakeDate a date is created.

Regards,

Jagan.

Date to a variable

Tue, 08 Nov 2011 15:13:18 GMT

Hi,

The expression Jagan gave you will give you the date of the max values selected for year, month and day, this means that if the user selects more than one value for any of those list boxes, the resulting date will be the max posible date.

If you want to force the user to select just one value for each list box then you can check the option "Always one selected" in the list box properties or you can modify the Jagan's expression to:

MakeDate(only(Year), only(Month), only(Day))

this will give you the date only if one value in each field is selected

Hope this helps

Regards!

Date to a variable

Tue, 08 Nov 2011 15:32:01 GMT

Thanks for the reply guys. Gabriela that was a good point.

But when I execute the script using MakeDate(only(Year), only(Month), only(Day))

I get script line error, any idea why we get that and how to fix that.

Date to a variable

jagan — Tue, 08 Nov 2011 15:36:43 GMT

Where are you using this variable in Script or in Expression of a chart.

Regards,
jagan.

Date to a variable

Tue, 08 Nov 2011 15:40:04 GMT

I am creating the variable in the script like

LET vPickDate = MakeDate(only(Year), only(Month), only(Day))

When I run the script I get script line error and so the variable is not created

Date to a variable

Tue, 08 Nov 2011 15:50:21 GMT

HI,

try adding a ';' at the end of the sentence or use SET instead of LET

Hope this helps

Date to a variable

Tue, 08 Nov 2011 15:53:26 GMT

Thanks Gabriela set worked!

Date to a variable

Tue, 08 Nov 2011 15:55:49 GMT

But SET gives that as a string and doesn't populates the variable when some thing is selected in the list box

Date to a variable

Tue, 08 Nov 2011 15:58:18 GMT

you need to use $(vPickDate) in your expression

Date to a variable

Tue, 08 Nov 2011 16:04:20 GMT

I am still trying to create variable in edit script using the line

LET vPickDate = MakeDate(only(Year), only(Month), only(Day));

and that gives me script line error.

Thanks!