Sorting filed values '-' as Topmost in dimension

[qlikcheepirishe]

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

PFA below

[prma7799]

try this

or may be your data model association is not created properly

[qlikcheepirishe]

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

[prma7799]

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

[qlikcheepirishe]

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

[greend21]

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

[greend21]

If it is a dimension then see the Sort tab.

[MK9885]

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

[MK9885]

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.