topic Re: Sorting Cyclic group by Expression for not working in QlikView

Sorting Cyclic group by Expression for not working

pragyaagrawal — Wed, 26 Oct 2016 14:16:50 GMT

Dear QlikViewers,

I need urgent help here!

I have a combo chart and straight table, both have a cyclic group and complex expression.I need to sort the cyclic group according to expression (DESC). I do not understand why its not working.

Please help here..

Thanks,

Pragya

Re: Sorting Cyclic group by Expression for not working

sunny_talwar — Wed, 26 Oct 2016 16:17:12 GMT

Straight table can be directly sorted by the expression itself. You don't have to sort it using an expression for the dimension. Have you tried that already?

Re: Sorting Cyclic group by Expression for not working

pragyaagrawal — Thu, 27 Oct 2016 08:05:56 GMT

Hi Sunny,

Thanks for reply.

I have tried both. sorting dimension on particular expression and sorting by expression directly. Both returning same wrong result.

sorting dimension on particular expression

sorting by expression directly

Re: Sorting Cyclic group by Expression for not working

sunny_talwar — Thu, 27 Oct 2016 15:49:19 GMT

Would you be able to share a sample to look at this?