Turn Min(Measure) into a Dimension

[prees959]

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

[Anil_Babu_Samineni]

Not understanding, Will you provide snap shot

[sunny_talwar · Accepted solution]

May be something along these lines

=Aggr(Min(UnitPrice), SomeDimension)

[prees959]

‌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

[sunny_talwar]

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)

[prees959]

‌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

[sunny_talwar]

My bad, I meant the Axes tab.... It is disabled on the axes tab? Can you share an image or axes tab?

[prees959]

‌of course :

Regards,

phil

[sunny_talwar]

This is strange... is your chart detached by any chance?

[prees959]

‌ddefinitely not detache... it's a grid chart. does that make a difference?