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 

[qlikviewwizard]

Can you attach some sample data?

[sumit_ranjan_pa]

You can sort them numerically in descending way, rather sorting in Alphanumeric values. This will help in putting zeroes together.

[prma7799]

I am not able to share data but please find the image of that reports and values in highlighted in red and 0(green) will come in middle instated of bottom

[qlikviewwizard]

Hi prma7799‌,

Try like this

[prma7799]

I have already done this ..

I have 7 expression in my chart.

[qlikviewwizard]

What are the dimensions? disable the sorting of others.

[qlikviewwizard]

BTW, can you share us the screen of sorting?

[prma7799]

Please find the attachment I have put sorting on highlighted column.

I have used below expression for sort.

(SUM({$<FiscalYear={$(=max(FiscalYear))}>}Value) )/100000

[prma7799]

I have set sorting for all dimension