topic Re: Turn Min(Measure) into a Dimension in QlikView

Turn Min(Measure) into a Dimension

prees959 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Turn Min(Measure) into a Dimension

Anil_Babu_Samineni — Wed, 28 Jun 2017 15:31:38 GMT

Not understanding, Will you provide snap shot

Re: Turn Min(Measure) into a Dimension

sunny_talwar — Wed, 28 Jun 2017 16:09:58 GMT

May be something along these lines

=Aggr(Min(UnitPrice), SomeDimension)

Re: Turn Min(Measure) into a Dimension

prees959 — Fri, 30 Jun 2017 14:15:34 GMT

‌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

Re: Turn Min(Measure) into a Dimension

sunny_talwar — Fri, 30 Jun 2017 14:19:15 GMT

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)

Re: Turn Min(Measure) into a Dimension

prees959 — Fri, 30 Jun 2017 14:42:20 GMT

‌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

Re: Turn Min(Measure) into a Dimension

sunny_talwar — Fri, 30 Jun 2017 14:55:27 GMT

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

Re: Turn Min(Measure) into a Dimension

prees959 — Fri, 30 Jun 2017 15:24:36 GMT

‌of course :

Regards,

phil

Re: Turn Min(Measure) into a Dimension

sunny_talwar — Fri, 30 Jun 2017 15:29:40 GMT

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

Re: Turn Min(Measure) into a Dimension

prees959 — Fri, 30 Jun 2017 16:18:34 GMT

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

Re: Turn Min(Measure) into a Dimension

sunny_talwar — Fri, 30 Jun 2017 16:20:36 GMT

That might be it... I have not worked with it before... but it may not have min and max axes available

Re: Turn Min(Measure) into a Dimension

prees959 — Fri, 30 Jun 2017 16:31:39 GMT

‌do you know of any way I could achieve this ? seems like I need a chart with symbols that show the qty but with a date dimension on the x axis and a evenly spaced y-axis....

im stumped

Re: Turn Min(Measure) into a Dimension

sunny_talwar — Fri, 30 Jun 2017 16:32:58 GMT

Would it be possible for you to share a sample app for us to play around?

Re: Turn Min(Measure) into a Dimension

prees959 — Sun, 02 Jul 2017 11:51:19 GMT

Hi Sunny,

Sorry for the delay. I've attached a sample app.

If you selected 'Gilmour D' as a salesperson, I would like to be able to see an equal spread on the y-axis :

were the values would start on £14 going up in .50 increments £14.00, £14.50, £15.00 upto £19.50....

Is this possible?

Phil

Re: Turn Min(Measure) into a Dimension

prees959 — Tue, 04 Jul 2017 10:29:14 GMT

Hi Again,

Any thoughts on the sample App Sunny?

Many thanks for your help!

Phil

Re: Turn Min(Measure) into a Dimension

sunny_talwar — Thu, 06 Jul 2017 08:55:10 GMT

May be check this link

Static min and max for Grid Chart | Qlik Community