Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Simon
Your answer was almost correct
It is not
SET Formule=(="sumformula");
BUT
SET
Formule="=sumformula";
Thanks for the inspiration within your answer
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");
Hello Simon
Your answer was almost correct
It is not
SET Formule=(="sumformula");
BUT
SET
Formule="=sumformula";
Thanks for the inspiration within your answer