Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

 

Labels (1)
1 Solution

Accepted Solutions
Saravanan_Desingh
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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.