Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to have a y-axis of Min(UnitPrice) on a GridChart.....
Is this possible? Is there some Qlik trickery I could employ to get this?
Thanks for any help
Phil
May be something along these lines
=Aggr(Min(UnitPrice), SomeDimension)
Not understanding, Will you provide snap shot
May be something along these lines
=Aggr(Min(UnitPrice), SomeDimension)
Hi Sunny,
This did the trick! Although, it only shows exact prices on the y-axis. Is it possible to scale the y-axis in distinct steps as a whole number just below the min and a whole number just above the max. So, if my values range from €10.30 to €76.76 my y-axis will start at €10.00 and increase in €5.00 steps to €80.00 ?
thansk again
Phil
You should be able to use a static min and static max for this on the presentation tab
Static min expression
Floor(Min(TOTAL Aggr(Min(UnitPrice), SomeDimension)), 5)
Static max expression
Ceil(Max(TOTAL Aggr(Min(UnitPrice), SomeDimension)), 5)
HI,
Thanks again for your reply. I have looked at th Presentation Tab and there doesn't seem to be an option to set the scale. Although on the axes tab the scale option has been disabled.
Any thoughts ?
Regards
Phil
My bad, I meant the Axes tab.... It is disabled on the axes tab? Can you share an image or axes tab?
of course :
Regards,
phil
This is strange... is your chart detached by any chance?
ddefinitely not detache... it's a grid chart. does that make a difference?