topic Usage of variable in a Expression in QlikView

Usage of variable in a Expression

Thu, 08 Oct 2009 16:34:26 GMT

Hi Guys,

I have a Date(30.06.2009) set as a Variable(vDate) and assigned to a calenderobject. I want to use this variable in the Expression of a chart. if there are other fields like BegDate with 2 input fields =2005-01-01,2009-01-01 and EndDate with 2 input fields as 9999-12-31,2008-12-31

For ex:- If(vDate >=BegDate and vDate <=EndDate, cond1, cond2)

it must select the fields BegDate=2009-0-01 and EndDate=9999-12-31 and give the cond1 correctly

but that doesnot happen. Any ideas?

Regards

Sravan

Usage of variable in a Expression

stephencredmond — Thu, 08 Oct 2009 18:10:20 GMT

Hi,

I can't understand exactly what you are trying to do.

Could you post a QVW and expand on your description?

Regards,

Stephen

Usage of variable in a Expression

Thu, 08 Oct 2009 18:49:42 GMT

I am attaching the example..

May be some one can help me.

Thanks[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Test.qvw]

Usage of variable in a Expression

Thu, 08 Oct 2009 18:52:11 GMT

I dont understand either but the date formats you show in your post are inconsistent (dots and hyphens). Yo may need to use the date# function to ensure correct interpretation as dates.

Regards,

Gordon

Usage of variable in a Expression

biester — Thu, 08 Oct 2009 19:20:36 GMT

Hi Sravan,

first:

you have to use date# as Gordon says. Then second, you have to use $(=VDate), third you have to enclose this in apostrophes like this:
date#('$(=VDate)','DD.MM.YYYY')
Forth: you have to use a aggregation, like = sum(if (.....
And fifth: it will NEVER work when the name of the variable is VDate and you use vDate in your expression.

Rgds,
Joachim

Usage of variable in a Expression

biester — Thu, 08 Oct 2009 19:24:49 GMT

Unfortunately one cannot edit one's own posts any more - I forgot to attach the modified test.qvw.

Rgds,
Joachim

Usage of variable in a Expression

Thu, 08 Oct 2009 19:44:45 GMT

Hi Joachim,

You are Great. Thanks

Fifth one is a little bit Spicy 😉

Regards

Sravan

Usage of variable in a Expression

biester — Thu, 08 Oct 2009 19:57:39 GMT

spicy but true. It took me two minutes to modify the expression so that it should work and another 20 minutes to find out why it DIDN'T work. I already wanted to give up when suddenly I hade a horrible suspicion ;-).

Rgds,
Joachim

Usage of variable in a Expression

Thu, 08 Oct 2009 20:02:49 GMT

@ Joachim

It is good but as I am using it in a Nested If statement usage of Sum is giving a syntax error..It doesnot suit in the Syntax..

Usage of variable in a Expression

Thu, 08 Oct 2009 20:04:16 GMT

Sorry for that. As I made the test example very fastly I made the Mistake..

Usage of variable in a Expression

biester — Thu, 08 Oct 2009 20:07:57 GMT

OK, perhaps sum is not applicable, I used it only as an example. It's just that you should have an aggregat function in a pivot table expression; perhaps min or max or firststring could work.

Rgds,
Joachim

Usage of variable in a Expression

Thu, 08 Oct 2009 20:30:57 GMT

Vielendank it works

Sravan

Usage of variable in a Expression

biester — Thu, 08 Oct 2009 20:33:13 GMT

Bestens! Gern geschehen!

Joachim