topic Field as variable in QlikView

Field as variable

shahamel — Fri, 17 Aug 2012 10:03:19 GMT

Dear Qlikview Users,

On this forum i came across an application which uses a variable as a field. On the upper left side of the dashboard you can see the field: FIELD. On the bottom you see an inputbox with three variables. When you change your selection in the field FIELD you can see that the variables are changing automaticly. I want to know how these variables were made.

In other words what is the script in order to make a variable which react on a fieldselection?

I really appriciate any help from QV-users.

Gr. Sandeep

Re: Field as variable

Fri, 17 Aug 2012 10:39:39 GMT

hello

look in settings > Variable Overview

the variable SumGraph = a field called sumformula

if you now look in load script it can be:

Graphformula:

LOAD * INLINE [

field, sumformula, avgformula

Sales, sum(Sales), avg(Sales)

Quantity, sum(quantity), Avg(Sales)

];

SET Formule=(="sumformula");

Re: Field as variable

shahamel — Fri, 17 Aug 2012 10:55:18 GMT

Hello Simon

Your answer was almost correct

It is not

SET Formule=(="sumformula");

BUT

SET

Formule="=sumformula";

Thanks for the inspiration within your answer