topic Re: Missing value from chart in QlikView

Missing value from chart

Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Missing value from chart

rubenmarin — Tue, 09 Jun 2015 11:53:24 GMT

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 '-'.

Re: Missing value from chart

Tue, 09 Jun 2015 12:36:27 GMT

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