topic Re: Store formulas in variable in QlikView

Store formulas in variable

Fri, 07 Oct 2011 16:14:25 GMT

Hi all,

I am very new in Qlik, and I would like to know how to give my users predefined formulas that they can use in their expressions. For example, I want to create a variable named sum_qty = "sum(QTY)" and I want my user to use sum_qty in his expression, but I am not able to get it to work.

Thank you in advance

Store formulas in variable

rwunderlich — Fri, 07 Oct 2011 16:23:15 GMT

Define the variable in one of two ways:

1. In the script:

SET sum_qty=sum(QTY);

2. In the Variable overview dialog.

Users then reference the variable in an expression as:

$(sum_qty)

-Rob

Store formulas in variable

Fri, 07 Oct 2011 16:24:42 GMT

Hi Carlo, you can store the expressions in an xl spreadsheet and read these expressions in your script.

Store formulas in variable

its_anandrjs — Fri, 07 Oct 2011 16:26:47 GMT

Hi,

Yes you can

make a variable named QTY_SUM = Sum(QTY)

And use this variable in any expression like $(QTY_SUM)

Rgds

Anand

Re: Store formulas in variable

its_anandrjs — Fri, 07 Oct 2011 16:28:19 GMT

Hi,

See the sample file

Rgds

Anand

Store formulas in variable

Fri, 07 Oct 2011 16:32:25 GMT

Thank you all very much, I was not able to reference the variable in the expression

Regards

Re: Store formulas in variable

its_anandrjs — Fri, 07 Oct 2011 16:32:31 GMT

Hi,

You can use any type of formulas like Max,Min,Sum,Count etc

See the attached sample file.

Rgds

Anand

Re: Store formulas in variable

its_anandrjs — Fri, 07 Oct 2011 16:38:11 GMT

Hi,

You have to use the values of stored variables in expression like

See the attached sample file

Rgds

Anand

Re: Store formulas in variable

Fri, 07 Oct 2011 17:06:39 GMT

It would be a good idea to check the way you are defining the variables and the way you are using them as qv is case-sensitive. It maybe something as small as this that maybe hampering the ref.