Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Mini chart error message.

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

1 Solution

Accepted Solutions
Not applicable

Re: Mini chart error message.

Yoh,

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

if(sum=0,1,sum)

Thanks a lot.

Jorge

4 Replies
srikanthsri1
Valued Contributor

Re: Mini chart error message.

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

Not applicable

Re: Mini chart error message.

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

srikanthsri1
Valued Contributor

Re: Mini chart error message.

then in that expresion

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

Not applicable

Re: Mini chart error message.

Yoh,

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

if(sum=0,1,sum)

Thanks a lot.

Jorge

Community Browser