Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Maybe use a double scale chart can help you.
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.