Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor II

Re: Need help on creating Y Axis scale in Grid Chart

Maybe use a double scale chart can help you.

serj_shu
Valued Contributor

Re: Need help on creating Y Axis scale in Grid Chart

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

Community Browser