topic Re: Some Values not shown in Chart in QlikView

Some Values not shown in Chart

Harry2001 — Wed, 25 Nov 2020 16:16:04 GMT

I am new to QlikView and tried to show some easy data in QlikView. Now some data are shown in a chart, some not. What can this be?

the data of month 2 is not shown (see picture attached)

Re: Some Values not shown in Chart

anushree1 — Tue, 13 Aug 2019 08:31:37 GMT

can u share the sample file

Re: Some Values not shown in Chart

marcus_sommer — Tue, 13 Aug 2019 08:35:35 GMT

Maybe there are another selections applied or there is a further condition within the dimension or expression.

- Marcus

Re: Some Values not shown in Chart

Harry2001 — Tue, 13 Aug 2019 08:47:34 GMT

attached you will find the file.

I can't see any other selections applied (I think the green point shows the applied selections).

Re: Some Values not shown in Chart

marcus_sommer — Tue, 13 Aug 2019 08:53:43 GMT

You need to use an aggregation-function - you should do it always ven if it might work without - because without such function the result will be always NULL if there are more than a single value available. In short use:

sum(menge_stunden)

- Marcus

Re: Some Values not shown in Chart

Harry2001 — Tue, 13 Aug 2019 09:04:02 GMT

Oh that easy, sorry i thought the "Akkumulation" is this function.

But now it works.

Thanks for your help.