help with linear guage max and min value expression

[Anonymous]

Hi Qlikgurus,

                    i have a pivot table with 3 dimension and also representing a minichart(linear guage).when all 3 dimension are expanded the linear guage bar looks fine but when we collapse the dimension them the linear guage breaks out and doesn't represent correctly.

for example the bar looks same for 100000 and 2100000

can any one suggest a good work around to this issue

[rwunderlich]

Will you get the effect you want if you change your gauge max to aggr by country only?

max(aggr(sum(sales),country))

-Rob

[Anonymous]

thanks rob for your reply,

for this example it might works but in my appilcation i'm using 3 dimensions as 3 cyclic groups

and most important ..is when we expand all three dimension then the max values bars doesn't cover the whole area(cell)... we (developers ) know the reason but our users got confused and doesn't liked it that way

any other workaround plz

[Anonymous]

i know it doesn't make sense in terms of syntax but as requirement prospective

i want some expression like

if (pivot table =expanded, max(aggr(sum(sales),country,region,city)),max(aggr(sum(sales),country)))

is there a way to get this

[Anonymous]

i used dimensionality() functiion

and the expression is  

if(dimensionality()=3,max(aggr(sum(sales),country,region,city)),

if(dimensionality()=1,max(aggr(sum(sales),country)),

if(dimensionality()=2,max(aggr(sum(sales),country,region)))))

but it's showing error mesage bad min or max values

[Anonymous]

seems like a bug to me ..can some body conform plz