topic Re: Rank on Field having empty values. in QlikView

Rank on Field having empty values.

retko1985 — Thu, 05 Apr 2018 12:37:44 GMT

Hello,

I am using ONLY aggregation function to display the values (cant use SUM etc.), now I have a problem, where I need to rank the values, and values having empty string are ranked above the others. But I need them to be below.

Here is an example:

I am also attaching this example file.

Thank you very much.

Re: Rank on Field having empty values.

olivierrobin — Thu, 05 Apr 2018 12:47:25 GMT

hello

it's strange

in doc, we see :

Ranking functions in charts

These functions can only be used in chart expressions.

Suppression of zero values is automatically disabled when these functions are used. NULL

values are disregarded.

Re: Rank on Field having empty values.

sunny_talwar — Thu, 05 Apr 2018 12:50:46 GMT

May be use this if you want the rank to be null for when the sales is null?

Rank(Only({<Sales = {"=Len(Trim(Sales)) > 0"}>}Sales),0,1) -> For Blank Sales (not null)

Rank(Only({<Sales = {"*"}>}Sales),0,1) -> For when Sales is truly null

Re: Rank on Field having empty values.

retko1985 — Thu, 05 Apr 2018 14:37:59 GMT

Great, Thank you