topic Re: Sorting Issue with 0 values in QlikView

Sorting Issue with 0 values

prma7799 — Tue, 10 Jul 2018 06:09:57 GMT

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

Re: Sorting Issue with 0 values

qlikviewwizard — Tue, 10 Jul 2018 06:18:04 GMT

Can you attach some sample data?

Re: Sorting Issue with 0 values

sumit_ranjan_pa — Tue, 10 Jul 2018 06:32:28 GMT

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

Re: Sorting Issue with 0 values

prma7799 — Tue, 10 Jul 2018 06:37:45 GMT

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

Re: Sorting Issue with 0 values

qlikviewwizard — Tue, 10 Jul 2018 06:41:51 GMT

Hi prma7799‌,

Try like this

Re: Sorting Issue with 0 values

prma7799 — Tue, 10 Jul 2018 06:59:56 GMT

I have already done this ..

I have 7 expression in my chart.

Re: Sorting Issue with 0 values

qlikviewwizard — Tue, 10 Jul 2018 07:09:24 GMT

What are the dimensions? disable the sorting of others.

Re: Sorting Issue with 0 values

qlikviewwizard — Tue, 10 Jul 2018 07:09:41 GMT

BTW, can you share us the screen of sorting?

Re: Sorting Issue with 0 values

prma7799 — Tue, 10 Jul 2018 07:14:27 GMT

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

I have used below expression for sort.

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

Re: Sorting Issue with 0 values

prma7799 — Tue, 10 Jul 2018 07:15:00 GMT

I have set sorting for all dimension

Re: Sorting Issue with 0 values

olivierrobin — Tue, 10 Jul 2018 07:35:06 GMT

hello

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

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

Re: Sorting Issue with 0 values

ogautier62 — Tue, 10 Jul 2018 07:58:47 GMT

Hi,

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

not only for the first one

regards

Re: Sorting Issue with 0 values

prma7799 — Tue, 10 Jul 2018 08:25:38 GMT

Already given...

Re: Sorting Issue with 0 values

prma7799 — Tue, 10 Jul 2018 08:25:52 GMT

Tried but no luck

Re: Sorting Issue with 0 values

olivierrobin — Tue, 10 Jul 2018 08:42:25 GMT

here is what I did

Re: Sorting Issue with 0 values

qlikviewwizard — Tue, 10 Jul 2018 08:54:07 GMT

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?