Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using a boundary with variables

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

3 Replies
its_anandrjs

Hi,

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

Ex:-

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

Or

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

Regards

Anand

its_anandrjs

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)

oppp.png

Regards

Anand

Not applicable
Author

Hi Anand,

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

Cheers Ines