5 Replies Latest reply: Aug 16, 2012 9:03 AM by Raj vadde

# help with linear guage max and min value expression

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

• ###### Re: help with linear guage max and min value expression

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

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

-Rob

• ###### Re: help with linear guage max and min value expression

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

• ###### Re: help with linear guage max and min value expression

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

• ###### Re: help with linear guage max and min value expression

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

• ###### Re: help with linear guage max and min value expression

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