topic Re: Chart with set dimensions with variables in QlikView

Chart with set dimensions with variables

danosoft — Mon, 07 Oct 2019 08:31:13 GMT

Hi i need to do a Chart with setting dimensions with some variables; i wanna change my dimensions and expression at runtime changing my variables.

For example i have trhee Variables: varone, vartwo, varthree

i wanna to change dimensions and selected expressions when i change the vars's values (for example with a listbox or bottons)

look at the picture

zhadrakas — Tue, 08 Oct 2019 08:35:50 GMT

check the appended .qvw for an idea how to solve that.

see tab "Reports"

regards

tim

danosoft — Tue, 08 Oct 2019 15:54:05 GMT

Thanks this is an interesting idea, but in reality it not reply to my question.

But i tried something and i find the solution using this variable for example:

SET varFirDimension = 'DinFirDimension';

tableDynamicOne:
LOAD RecNo() as %ID,
SubField(string,'-') as DinFirDimension
Inline [
string
one-two-three-four
];

and in the dimension of my chart i use: =$(='[' & $(varFirDimension) & ']')