topic Re: QlikView: Supress Zero Value in combination with above() in QlikView

QlikView: Supress Zero Value in combination with above()

Anonymous — Thu, 29 Sep 2016 18:18:48 GMT

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:

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

Now I select a Year:

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

sunny_talwar — Thu, 29 Sep 2016 18:24:55 GMT

I am not seeing the same issue as you

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

Anonymous — Thu, 29 Sep 2016 18:33:20 GMT

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 — Thu, 29 Sep 2016 18:37:04 GMT

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

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

rupamjyotidas — Thu, 29 Sep 2016 18:39:44 GMT

Maybe because '+' means

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

Anonymous — Thu, 29 Sep 2016 18:48:30 GMT

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.