Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QlikView: Supress Zero Value in combination with above()

Hello, just a very simple example:

tab:
LOAD * INLINE [
Year, Value
2013, 10
2014, 20
2015, 30
2016, 40
]
;

I created a chart with dimension Year and the following expression:

Abovesum( {<Year += {$(=max(Year)-1)}>}Value))

Now I select a Year:

I don't understand why the marked line is still  visibile?!?

1 Solution

Accepted Solutions
sunny_talwar

I am not seeing it in the file you attached as well

Capture.PNG

What version of QV12 are you using? I am using QV12 SR5

View solution in original post

5 Replies
sunny_talwar

I am not seeing the same issue as you

Capture.PNG

Do you still see that one row when you open the attached file?

Anonymous
Not applicable
Author

I cant't test it now, because I have only QlikView 12 Personal Edition here.

For me it looks like a bug.

Please have a look at my attachment...

sunny_talwar

I am not seeing it in the file you attached as well

Capture.PNG

What version of QV12 are you using? I am using QV12 SR5

rupamjyotidas
Specialist
Specialist

Maybe because '+' means

'using an implicit union to add the products “2015" to the list of selected products.'

Anonymous
Not applicable
Author

Yes I thought something similar, that's why my question...

First I used QV12 SR1, now I updated to a newer version and it works as supossed.