topic Re: Pivot table blank rows sort in QlikView

Pivot table blank rows sort

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Below is the report which we have developed and we need to sort the market(Oklahoma) which are in blank in bottom of the report.

Re: Pivot table blank rows sort

adamdavi3s — Thu, 17 Nov 2016 08:37:30 GMT

I'd advise sorting the dimension by some expression, without a qvw to work with its tricky to say what but in simplistic terms this is just sorted on the value of someotherdimension bb descending. However I suspect that your requirements are more complex than this in reality?

Re: Pivot table blank rows sort

Anonymous — Thu, 17 Nov 2016 09:08:32 GMT

Hi Naresh,

Use following steps:

RightClickOnTable-->Properties-->Sort-->Sort all requires dimensions in numeric Value-->Descending Order

Thanks,