topic Re: Strange behaviour when max(expression) returns 0 in QlikView

Strange behaviour when max(expression) returns 0

benjamins — Wed, 10 Sep 2014 07:46:04 GMT

Please see attached sample.

My problem is the following.

I have a DIMENSION and VALUES for that dimension. In this extremely simple sample the pairs are.

1 / 0

1 / 1

2 / 1

3 / 0

I now create a chart with DIMENSION as dimension and max(VALUE) as expression.

While for 1 and 2 I get the expected "1", I would expect to get "0" for DIMENSION = 3 which I don't. I don't get a value at all.

So for this case as of now I use a workaround. Why does Qlikview behave like that? Am I missing something? What is the best way to deal with this problem?

Thanks everyone and have a great day.

Cheers

Benjamin

Re: Strange behaviour when max(expression) returns 0

Gysbert_Wassenaar — Wed, 10 Sep 2014 07:56:29 GMT

Disable the option Suppress Zero-Values on the Presentation tab of the charts properties window.

Re: Strange behaviour when max(expression) returns 0

benjamins — Wed, 10 Sep 2014 08:07:45 GMT

Thank you very much.I kind of feel quite stupid right now.

Re: Strange behaviour when max(expression) returns 0

Gysbert_Wassenaar — Wed, 10 Sep 2014 08:11:28 GMT

No worries, I often do too. . On the bright side, you're not likely to forget this option any time soon now.