Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Nora104
Partner - Creator
Partner - Creator

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

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)?

Nora104_0-1599795109258.png

 

1 Solution

Accepted Solutions
Saravanan_Desingh

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
;

commQV73.PNG

View solution in original post

5 Replies
rubenmarin

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.

Saravanan_Desingh

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
;

commQV73.PNG

PerkyBadger
Contributor
Contributor

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

Nora104
Partner - Creator
Partner - Creator
Author

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!

Nora104
Partner - Creator
Partner - Creator
Author

Thank you.

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