topic Re: Sorting filed values '-' as Topmost in dimension in QlikView

Sorting filed values '-' as Topmost in dimension

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

My requirement is that dimension having " - " should appear in the top what will be steps to fullfill the requirement

PFA below

prma7799 — Thu, 02 Nov 2017 06:22:05 GMT

try this

or may be your data model association is not created properly

qlikcheepirishe — Thu, 02 Nov 2017 06:32:01 GMT

in pivot want to show in in first position for ' - ' in Area and Sub Area

prma7799 — Thu, 02 Nov 2017 06:35:25 GMT

Please share some sample app or do sorting on SUB AREA as ascending

qlikcheepirishe — Thu, 02 Nov 2017 07:14:56 GMT

I required null values to be positioned on top how could i achieve it

greend21 — Thu, 02 Nov 2017 19:28:04 GMT

Try sorting your numbers is Ascending order on the Number tab of the Chart Properties. That should put null values at the top.

greend21 — Thu, 02 Nov 2017 19:28:48 GMT

If it is a dimension then see the Sort tab.

MK9885 — Thu, 02 Nov 2017 20:28:40 GMT

It can be done in script but can you provide a small sample data as more than 1 dimension has - value

MK9885 — Thu, 02 Nov 2017 20:33:33 GMT

You could try

LOAD * INLINE [

SortUnit, Unit,

1, -

];

In frontend sort by expression by just giving SortUnit and descending.

that may work, not sure though.