topic Chart (pivot table) sort by expression ignoring zero's (null?) in QlikView

Chart (pivot table) sort by expression ignoring zero's (null?)

guyvermeiren — Tue, 22 Feb 2011 14:06:26 GMT

Hello,

I have a pivot table with several expressions and one dimension. Now I want to sort 'descending' one of the expression-columns.

The problem I get is that it shows first a number of zero values and then starts ith the highest value (see example sort / sort by Turnover 2007). Has this got to do with the fact that the zero's represent missing data ???

How can I solve this problem ??

Thanks,

Guy

Chart (pivot table) sort by expression ignoring zero's (null?)

Tue, 22 Feb 2011 14:10:52 GMT

Perhaps: in presentation tab delete values null

Chart (pivot table) sort by expression ignoring zero's (null?)

guyvermeiren — Tue, 22 Feb 2011 14:24:53 GMT

Hello,

We already tried to use these options in the presentation tab.

No succes.

Kind regards,

Guy

Chart (pivot table) sort by expression ignoring zero's (null?)

Tue, 22 Feb 2011 14:47:15 GMT

try sort by expression and put your expression...

are you sure that "0" is considerated as a null value?

Chart (pivot table) sort by expression ignoring zero's (null?)

guyvermeiren — Tue, 22 Feb 2011 15:04:04 GMT

Hello,

I don't exactly understand what you mean. We already worked by "Sort by expression" putting in the expression.

It's at that moment that we get the the result as in the example.

First the zero's (probably the customers whithout turnover for that year) followed by the sort as it should be.

Kind regards,

Guy

Chart (pivot table) sort by expression ignoring zero's (null?)

Tue, 22 Feb 2011 15:06:38 GMT

Can you post an application with this table?

Re: Chart (pivot table) sort by expression ignoring zero's (null?)

Thu, 26 Jul 2012 12:09:03 GMT

For ones that are looking for the solution:

I had a similar problem. The solution is to sort by expression and in this expression use rank function, for ex.

rank(count(id)) and sort it ascending. This will solve the problem . It worked for me.

Re: Chart (pivot table) sort by expression ignoring zero's (null?)

Thu, 26 Jul 2012 12:09:24 GMT

For ones that are looking for the solution:

I had a similar problem. The solution is to sort by expression and in this expression use rank function, for ex.

rank(count(id)) and sort it ascending. This will solve the problem . It worked for me.