topic Re: Chart Min and Max Axes Properties in QlikView

Chart Min and Max Axes Properties

Anonymous — Tue, 02 Jul 2013 08:25:52 GMT

Is there a way to get the minimum and maximum value of the x and y axes of a chart in qlikview. I want to use these to set the min and max in another chart.

Thanks.

Joao.

Re: Chart Min and Max Axes Properties

kaushiknsolanki — Tue, 02 Jul 2013 08:34:41 GMT

Hi,

Simply copy the expression from the other chart.

Say if the expression is Sum(Amount)

Then create an expression for Min x value of other chart as

Min(Aggr(Sum(Amount),Dimension)

for max as

Max(Aggr(Sum(Amount),Dimension)

Regards,

Kaushik Solanki

Re: Chart Min and Max Axes Properties

Anonymous — Tue, 02 Jul 2013 08:49:45 GMT

Excellent. This works.

Thank you.