Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
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
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
Excellent. This works.
Thank you.