Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Yoh,

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

if(sum=0,1,sum)

Thanks a lot.

Jorge

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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
Author

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

Anonymous
Not applicable
Author

then in that expresion

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

Not applicable
Author

Yoh,

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

if(sum=0,1,sum)

Thanks a lot.

Jorge