Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Harry2001
Contributor
Contributor

Some Values not shown in Chart

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)

 

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

5 Replies
anushree1
Specialist II
Specialist II

can u share the sample file

marcus_sommer

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

- Marcus

Harry2001
Contributor
Contributor
Author

attached you will find the file.

 

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

marcus_sommer

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

Harry2001
Contributor
Contributor
Author

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

But now it works.

Thanks for your help.