Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
shahamel
Creator
Creator

Field as variable

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

1 Solution

Accepted Solutions
shahamel
Creator
Creator
Author

Hello Simon

Your answer was almost correct

It is not

SET Formule=(="sumformula");

BUT

SET

Formule="=sumformula";

Thanks for the inspiration within your answer

View solution in original post

2 Replies
Not applicable

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
Creator
Creator
Author

Hello Simon

Your answer was almost correct

It is not

SET Formule=(="sumformula");

BUT

SET

Formule="=sumformula";

Thanks for the inspiration within your answer

View solution in original post