Discussion Board for collaboration on QlikView Layout & Visualizations.
I was wondering if it would be possible to make a variable an expression i.e. write the expression in the variable field and have the variable as the definition for the expression.
I want to make buttons that change the variable which shows up in the line graph.
i did it once defining the variable from Variable Overview (setting menu) .
I added a new variable vYearSelected and defined as =If(GetPossibleCount([Year])=1,[Year],max([Year])).
Everytime i change the Year selection, the variable change value automatically.
I think that you can do that also in script using the SET command
SET vYearSelected ='=If(GetPossibleCount([Year])=1,[Year],max([Year]))';
but i never tested it
of course you can do this:
SET vSum = 'Sum(Sales)'; (in script)
or define them in the variablelist in settings only the text:
in the expression:
Greetings from Munich