topic Re: Mini chart error message. in QlikView

Mini chart error message.

Fri, 03 Aug 2012 16:13:42 GMT

Hi there,

Could somenone help? I have a straight table with a cyclic group of dimensions and on the expression, I have a linear gauge chart showing sum result for these dimension.

The question is; How can I not display on the straigh table expression chart column the error message showing on the file I have attached here, when I dont have values for my sum?

Kind regards,

Jorge

Re: Mini chart error message.

Anonymous — Fri, 03 Aug 2012 17:13:01 GMT

the vaule of limits in the guague setting are bad ..so that is the reasons that error msg is popping up ..can you post a sample file so that i can look at the expression used and solve your problem

Re: Mini chart error message.

Fri, 03 Aug 2012 17:30:20 GMT

It is a sum expression, and when the result is 0 it shows that error.

Re: Mini chart error message.

Anonymous — Fri, 03 Aug 2012 17:33:34 GMT

then in that expresion

if(len(expression)<='1',1,expression)

Re: Mini chart error message.

Fri, 03 Aug 2012 17:37:47 GMT

Yoh,

I´ve got that one and without the len function, works good.

if(sum=0,1,sum)

Thanks a lot.

Jorge