topic defining variables in QlikView

defining variables

Wed, 17 Aug 2011 06:48:58 GMT

hello,

I'm new to QlikView ,I defined a variable in variable Overview and i tried to display it on the dashbaord using a straight table but it didn't return any values, on the contrary it 's returning the script itself

example:

variable's name is : " EE1"

definition:

(date([Effective Date])> '30/05/2011' or date([Insured Date])> '30/05/2011',$(EE1) =0,

(date([Insured Date]) < '01/01/2011',

(date([Policy Expiry Date]) < '31/12/2010', $(EE1) =Round((date([Policy Expiry Date])-date([Insured Date]) +1 )/365,0.0001),

(date([Policy Expiry Date]) >= '31/12/2010', $(EE1) =Round((date('31/12/2010')-date([Insured Date]) +1 )/365,0.0001),

(date([Expiry Date]) < '01/01/2011',

(date([Policy Expiry Date]) < '31/12/2010', $(EE1) =Round((date([Policy Expiry Date])-date([Expiry Date]) +1 )/365,0.0001),

(date([Policy Expiry Date]) >= '31/12/2010', $(EE1) =Round((date('31/12/2010')-date([Expiry Date]) +1 )/365,0.0001),

(date([Insured Date])>= '01/01/2011', $(EE1) =0))))))))

and

if(date([Policy Expiry Date])> date([Expiry Date]),$(EE1) = $(EE1) * (-1))

and when i want to display the values of this variable it returns the script itself..

Please can anyone help me, thanks in advance.

defining variables

kaushiknsolanki — Wed, 17 Aug 2011 06:52:46 GMT

Hi,

Add = at the beginning of the script in variable.

Regards,

Kaushik Solanki

defining variables

Thu, 18 Aug 2011 07:09:29 GMT

hello Kaushik,

Thank you so much for your answer, yet I tried to apply your advice and here's the following :

the expression of the variable didn't show anymore which is good but still no values,did i miss something in the script ?

Thanking you so much in advance.

defining variables

kaushiknsolanki — Thu, 18 Aug 2011 07:16:30 GMT

Hi,

I would say instead of using date in this way. i.e '30/05/2011' use

makedate(2011,05,30)

Change at every location, with respective date in makedate.

Regards,

Kaushik Solanki

defining variables

Thu, 18 Aug 2011 08:07:22 GMT

well Kaushik ,

i try it but i'm getting the same result, no values are show .

defining variables

kaushiknsolanki — Thu, 18 Aug 2011 08:13:02 GMT

Hi,

Is it possible to upload the qvw file.

Regards,

Kaushik Solanki

defining variables

Thu, 18 Aug 2011 08:52:41 GMT

Hi Christelle,

First, Im not sure if it is necessary for you to use the $(EE1) expression in your variable definition. I woud think that it would be expected of you to use it when you call the variable in the front end.

So, for instance, instead of writting

EE1 = If(date([Effective Date])> '30/05/2011' or date([Insured Date])> '30/05/2011',$(EE1) =0,else....... , you may just write:

EE1= If(date([Effective Date])> '30/05/2011' or date([Insured Date])> '30/05/2011', 0 ,else...

Secondly, I want to know, are you sure your current qlikview date format is 'DD/MM/YYYY' ? and not 'YYYY/MM/DD' for example?

defining variables

rahulgupta — Thu, 18 Aug 2011 09:11:58 GMT

Try this:

EE1=

(date([Effective Date])> '30/05/2011' or date([Insured Date])> '30/05/2011',0,

(date([Insured Date]) < '01/01/2011',

(date([Policy Expiry Date]) < '31/12/2010', Round((date([Policy Expiry Date])-date([Insured Date]) +1 )/365,0.0001),

(date([Policy Expiry Date]) >= '31/12/2010', Round((date('31/12/2010')-date([Insured Date]) +1 )/365,0.0001),

(date([Expiry Date]) < '01/01/2011',

(date([Policy Expiry Date]) < '31/12/2010', Round((date([Policy Expiry Date])-date([Expiry Date]) +1 )/365,0.0001),

(date([Policy Expiry Date]) >= '31/12/2010', Round((date('31/12/2010')-date([Expiry Date]) +1 )/365,0.0001),

(date([Insured Date])>= '01/01/2011', 0))))))))

Now take another variable:

EE2:

=if(date([Policy Expiry Date])> date([Expiry Date]),$(EE1) = $(EE1) * (-1))

defining variables

Thu, 18 Aug 2011 09:39:33 GMT

hello ,

my current qlikview date format is 'DD/MM/YYYY' and i also tried your method by removing the $(EE1)=.... but it didn't work.

defining variables

Thu, 18 Aug 2011 10:54:37 GMT

Please,

would it be possible for you to send us a QVW sample file?

Regards.

defining variables

Anonymous — Fri, 19 Aug 2011 06:05:19 GMT

check the date formats of all the fields.. like.. [Effectve Date], [Insured Date], etc... and if possible use fabs everywhere... convert the dates to numbers.. and then run your if conditions... also.. when you have multiple if conditions.. like these.. first breakdown all the if conditions seperately and then check.. if each of these if conditions are working... and which part is getting executed.. like the true part or the else part.. .like this you can debug and find the where the issue lies...

hope that helps..