topic SORTING ORDER in QlikView

SORTING ORDER

upaliwije — Thu, 30 Aug 2018 05:09:22 GMT

Hi friends

I have following expression in sort tab of my Pivot Table. But it does not work well. Total row comes in between records which in fact should be the last row.

Kindly let me the error I have done in expression

Re: SORTING ORDER

ogautier62 — Thu, 30 Aug 2018 07:02:02 GMT

Hi,

you want to be ordered by ratio on RM,

with total last row, ok ?

Total seem to be an item in RM,

if so try as sort expression on RM :

if(RM <> 'TOTAL', your ratio expression, 100)

regards