topic How to Create custom variable and use them in other expressions in QlikView

How to Create custom variable and use them in other expressions

Mon, 09 Jan 2012 10:34:11 GMT

Hi All ,

This is Ravindra Mandre and just before sometime started working on qlikview and obviously new to it.

While doing some table operations I came to a requirement of creating some custom variables that can be used in other calculations and other expressions which includes the use of created varibles . for example

I wanted to create one variable which will do some calculation like this

output_a= Count(variable_a) or AVG(variable_a)

and then variable_a does some other calculations like

variable_a = if(someDate=Now(2) and otherDate=SOME_OTHER_DATE, true , false);

So my question is that How I can create the custom variables so that I can use them into my calculations without repeating the same calculations again and again.

Please help .

Thanks & Regards

Ravindra Mandre

How to Create custom variable and use them in other expressions

Mon, 09 Jan 2012 15:35:48 GMT

Hello Ravindra,

I am not quite sure, but the $-sign expansion should help you.

For ex. :

output_a= Count( $(variable_a) ) or

output_a= Count( $(=variable_a) )

For further details please see help

Regards, Roland

Note:

For testing purpose or getting started you can edit some easy expressions in a textbox and see what's happening.

How to Create custom variable and use them in other expressions

louwriet — Mon, 09 Jan 2012 15:43:25 GMT

Hi Ravindra,

I hope I understand you right what you are trying to achieve.
To give you an example

Let say you have 2 variables :
eIncomeExl = sum(AmountExcl)
eDedutionsExl = sum((Deductions) * (-1)) /114 * 100

Then I create another variable:
eSales = $(eIncomeExl) - $(eDedutionsExl)

Then in my Qlikview expression I would want the sales I use =$(eSales)
or if you just need the income in the expression you can just use use =$(eIncomeExl)

How to Create custom variable and use them in other expressions

Tue, 10 Jan 2012 09:08:10 GMT

Hi Louwrie,

Many thanks for you reply and it helped me a lot.

Roland thanks to you also for reply.

Regards

Ravindra Mandre