Sorting Issue with 0 values

[prma7799]

Hi Experts,

I have a report in that I have sorted all as sum(sale) value

All values are coming sorted properly but I wants all 0 values should be at bottom

Please see attached.

Thanks 

[olivierrobin]

hello

in sort tab, why don't you sort with an expression like

if(sum(sales)=0,9999999999999999, sum(sales)

[ogautier62]

Hi,

maybe give the sum() sort expression for each dimension,

not only for the first one

regards

[prma7799]

Already given...

[prma7799]

Tried but no luck

[olivierrobin]

here is what I did

[qlikviewwizard]

Hi,

1. Why I am not seeing these expression Names in Sort??

2. Check for all the expressions Descending and uncheck Numerical Value.Hope this will help.

3. Can you open Expression tab and send screenshot?