Looks like QlikView does not rank zeros in Rank(), I have a requirement to rank zeros and NULL. For example:
Region | Week | Sales |
North America | 1 | 99 |
North America | 2 | 54 |
North America | 3 | 75 |
Europe | 1 | 52 |
Europe | 2 | 48 |
Europe | 3 | 0 |
Asia | 1 | 57 |
Asia | 3 | 45 |
For ranking by Region by Week, I should able to show Rank of Europe for week 3 as '3' and for Asia, for week 2 as '3' by converting NULL to 0. Tried "Sum({1}0)" in the Rank expression to convert NULL to 0 but still not able to Rank 0.
Any suggestions ?