Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Missing value from chart

Hello,

I have a problem with a chart.

It don't display the values because there are 2 values for the specific field. And I have a '-' symbol instead.

It is something that I can do ? Or the problem is from the data files ?

Thanks,

Claudiu

1 Solution

Accepted Solutions
rubenmarin

Hi Claudiu, if there are more than one value, you should tell QV what to do with those values, if it's a number you can use Sum(), Avg()... If it's a string you can use MinString(), Concat()...

First you need to decide wich value you want to be shown and why, then you can tell if the problem was on data files or if you want to solve that in script during reload or in chart while execution time.

If you don't solve how to treat several values, QV returns a Null(), usually represented by '-'.

View solution in original post

2 Replies
rubenmarin

Hi Claudiu, if there are more than one value, you should tell QV what to do with those values, if it's a number you can use Sum(), Avg()... If it's a string you can use MinString(), Concat()...

First you need to decide wich value you want to be shown and why, then you can tell if the problem was on data files or if you want to solve that in script during reload or in chart while execution time.

If you don't solve how to treat several values, QV returns a Null(), usually represented by '-'.

Not applicable
Author

Thanks a lot for your answer. I inserted a CONCAT() function, and now it's like I want it. Thanks!