topic Re: help with linear guage max and min value expression in QlikView

help with linear guage max and min value expression

Anonymous — Thu, 09 Aug 2012 14:16:23 GMT

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

rwunderlich — Thu, 09 Aug 2012 15:28:15 GMT

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

Anonymous — Thu, 09 Aug 2012 15:35:38 GMT

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

Re: help with linear guage max and min value expression

Anonymous — Thu, 09 Aug 2012 15:45:26 GMT

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

Anonymous — Wed, 15 Aug 2012 14:00:06 GMT

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

Anonymous — Thu, 16 Aug 2012 13:03:39 GMT

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