topic Re: Date variable in QlikView

Date variable

Thu, 21 Aug 2014 14:33:55 GMT

I have the following in my script:

select top 2000

CASE

cb.FinancialPeriod,

cb.Actual

from plc

where financialperiod between ($(v_userStart)) and ($(v_userEnd));

I have then setup the two variables in in the document properties with some dates set in both. However, when I reload the app no data appears. Can you please help? What am I missing?

Re: Date variable

jonathandienst — Thu, 21 Aug 2014 14:49:28 GMT

Not sure whar DBMS you are using, but it probably needs quotes on the dates, like this:

financialperiod between '$(v_userStart)' and '$(v_userEnd))'

HTH

Jonathan

Re: Date variable

jonathandienst — Thu, 21 Aug 2014 14:51:22 GMT

If that is not it, perhaps the variables are nor returning what you expect. If you switch to debug mode and put breakpoint before the Select, them you can step to that point and see exactly what query is being sent to the DBMS.

Re: Date variable

Thu, 21 Aug 2014 14:52:44 GMT

its a SQL db

Re: Date variable

jagan — Thu, 21 Aug 2014 15:03:04 GMT

Hi,

Check the variables whether they are getting values in it, may be that is the issue. Also date values need to be surrounded by single quotes.

select top 2000

CASE

cb.FinancialPeriod,

cb.Actual

from plc

where financialperiod between '$(v_userStart)' and '$(v_userEnd);

Also check the date formats are same in both variables and your date field.

Regards,

Jagan.

Re: Date variable

Thu, 21 Aug 2014 15:19:42 GMT

it looks like i had missing quotes. Thanks all

Re: Date variable

jagan — Thu, 21 Aug 2014 15:53:41 GMT

Hi,

Please close this thread by giving correct and helpful answer to the helpful posts.

Regards,

Jagan.