topic Re: Make a variable equal to a value range (0-100) in QlikView

Make a variable equal to a value range (0-100)

Nora104 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to make a line chart: X axis is a variable(0-100), Y axis is a value changed with the variable of X axis.

How can I make the variable be a value range(0-100)?

Re: Make a variable equal to a value range (0-100)

rubenmarin — Sun, 13 Sep 2020 07:43:45 GMT

Hi, I'm not sure of what data you have... In the Axis tab of the chart you can se a static min and stactic max.

You can use a variable to set any of the values using $(VariableName).

Also you can use an expression like Max([Expression_For_X_Axis]) to set the static max. Use Min() for the static min.

Re: Make a variable equal to a value range (0-100)

Saravanan_Desingh — Mon, 14 Sep 2020 04:04:25 GMT

Are you looking something like this? For example, Y=Sin(X) where X = 0 to 100

tab1: LOAD IterNo() As X, Sin(IterNo()) As Y AutoGenerate 1 While IterNo()<=100 ;

Re: Make a variable equal to a value range (0-100)

PerkyBadger — Mon, 14 Sep 2020 09:15:48 GMT

Looking great work dear, I really appreciated to you on this quality work. Nice post!!

Re: Make a variable equal to a value range (0-100)

Nora104 — Tue, 15 Sep 2020 07:31:49 GMT

It is just what I want. But I wonder if it can be done by variable so that the max value 100 can be changed easily. But I guess this way is good enough for my use.

Thank you!

Re: Make a variable equal to a value range (0-100)

Nora104 — Tue, 15 Sep 2020 07:37:21 GMT

Thank you.

But I am a little confused. I don't know whether what you say can solve my problem.