help in expression for limits of linear guage minichart

[Anonymous]

Hi Qlikgurus,

      i'm grouping two expression and next to it there should be a minichart  (linear guage) representing those values...........

if user selects the other expression value-the minichart bar should change to relative to  those expression ... so this  is the requirement

I solved a bit by using column function but the problem is with the minichart limits in it

the min and max vaules are working as expected.

here i'm attaching my sample file can anyone help me regarding this

thanks

have a great day

[Anonymous]

this is error i'm getting

can anyone guide what's the problem with my expression

[Anonymous]

any suggestion please i'm bit new  new to qlikveiw

[Anonymous]

the expression i'm using in linear guage setting is  max =if(column(1)==expression1, max( aggr( expression1,dim, dim2)),if(column(1)=expression2,max( aggr( expression2,dim, dim2)))  and  min=0

and it's showing me bad min or max vaules

can any one throw some light on it