Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help on creating Y Axis scale in Grid Chart

Hi All,

I need help on creating a Y -Axis scale in Grid chart in qlikview. Basically My requirement is to display month wise unit price for a particular Item Code.

I have attached the screenshot. I need to display the average line in this grid chart. But I am not able to do that as its not allowing me to fix the scale for Unit price.

Any ideas/Suggestions?

2 Replies
sergio0592
Specialist III
Specialist III

Maybe use a double scale chart can help you.

Sergey_Shuklin
Specialist
Specialist

Hello!

If you restricted with grid chart, so you'll have to convert your months from text to numbers and use some hints to calculate the average like:

avg(val)/max(val)*max(mon)

,where "mon" is your months converted to 1,2,3 and so on, and "val" is the value per month.

Why that? PFA below.

grid_chart.png