topic Re: Reusability of Expression in QlikView

Reusability of Expression

bimala0507 — Wed, 02 Apr 2014 06:11:12 GMT

Hi everyone:

Is there a way to re-use the expression defined in one chart in another chart. E.g. I have created a straight table, where I have made few calculations. The same expression I want in another chart. Is it doable. Can the expression be stored or made global to achieve. Basically if the formula changes in future you can change in one place and it will be automatically reflected in other place.

Appreciate a prompt response.

Thanks & Regards,

Bimala

Re: Reusability of Expression

tresB — Wed, 02 Apr 2014 06:13:01 GMT

Define your expression in a variable, and use that variable at as many places as you want to.

Re: Reusability of Expression

its_anandrjs — Wed, 02 Apr 2014 06:15:28 GMT

Yes you can store your expression in the variables and use this in n number of charts.

vSales = Sum(Sales)

Hope this helps

Re: Reusability of Expression

its_anandrjs — Wed, 02 Apr 2014 06:17:15 GMT

By pressing Ctrl + Alt + V go to variable window

vSales = Sum(Sales)

You can use this variable in any charts like $(vSales), =vSales

Hope this helps

Re: Reusability of Expression

MK_QSL — Wed, 02 Apr 2014 06:19:12 GMT

CTRL + ALT + V.... Create variables for the Expressions you have to use more than once ....

I.e.

Variable Name

vTotalSales

Definition

SUM(Sales)

Now you can use the variable as $(vTotalSales)

Re: Reusability of Expression

mangalsk — Wed, 02 Apr 2014 06:27:43 GMT

Hello,

create variable and give expression as value to that variable.

Now you can use this variable wherever you need that expression.

Regards

Re: Reusability of Expression

its_anandrjs — Wed, 02 Apr 2014 06:32:25 GMT

You can maintain any excel file for the expressions also and read from the file.

Hope this helps

Re: Reusability of Expression

arjunkrishnan — Wed, 02 Apr 2014 06:48:25 GMT

Create Variable For Expression Or Use Fast Change In Same Chart...

Re: Reusability of Expression

Anonymous — Wed, 02 Apr 2014 06:53:47 GMT

Hi,

Go to variable overview (Ctrl+Alt +V) and create a variable holding your expression. Use this variable where u want and this is global as per your requirement.!

Re: Reusability of Expression

Wed, 20 Aug 2014 15:00:20 GMT

Yes, you can reuse the Expression by storing it as a Variable.

Variables can be stored in Qlikview Document itself Ctrl+Alt+V or in external Qlikview script file ie qvs.

-Ram