Field as variable

[shahamel]

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

[#2]

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");

[shahamel · Accepted solution]

Hello Simon

Your answer was almost correct

It is not

SET Formule=(="sumformula");

BUT

SET

Formule="=sumformula";

Thanks for the inspiration within your answer