topic using a boundary with variables in QlikView

using a boundary with variables

Tue, 17 Feb 2015 12:44:40 GMT

Hi everybody,

I do have a problem with a set analyse.

I have two variables, var_from and var_to. (var_from = 10 ; var_to=20). I need to calculate the value of my variable between var_from and var_to and a tried it like this: {<VALUE = {">=$(Var_from) <=$(Var_to)”}>}, but it doesn't work.

Has anyone an idea how to do it?

Cheers Ines

Re: using a boundary with variables

its_anandrjs — Tue, 17 Feb 2015 13:02:15 GMT

Hi,

Your expression seems correct or you can try this way of expression

Ex:-

Sum({< VALUE = {'>=$(var_from) <=$(var_to)'} >} MetrcFieldHere )

Count({< VALUE = {'>=$(var_from) <=$(var_to)'} >} MetrcFieldHere)

Regards

Anand

Re: using a boundary with variables

its_anandrjs — Tue, 17 Feb 2015 13:18:09 GMT

Hi,

See this simple example

LOAD

IterNo() as VALUE,

Rand() * 100 as Amt

AutoGenerate 1 While IterNo() <= 100;

And in chart use

Dim:- VALUE

Expre:-

sum({< VALUE = {">=$(var_from) <=$(var_to)"} >} Amt)

Regards

Anand

Re: using a boundary with variables

Tue, 17 Feb 2015 14:17:31 GMT

Hi Anand,

thanks for qour quick reply. It works perfect for me.

Cheers Ines