Solved: how to replace NULL value as top most value in piv... - Qlik Community

Report Inappropriate Content · ‎2014-04-25

Hi,

Can anyone suggest me how can I get the replaced NULL value as top most value in pivot table? please see attached. As I replaced the Null Values with 'Not Default UTD' . I would need this at the starting of the column values.

Thanks.

eduardo_sommer · ‎2014-04-25

There is a simple way to do this. Before you load the main table, include the inline load below:

Labels:

Load * INLINE [

AgeSummary_March

Not Default UTD

1Month

1month

2months

3months

4months

5months

6months

7-11monts

12months+

];

It's importante that the name of the column, and the labels are exactly the same as in your table.

In the pivot table (order tab) choose input order. Since the inline load is executed before the load of your table, it will determine the input order.

Let me know if this worked for you.

View solution in original post

Report Inappropriate Content · ‎2014-04-25

Please see attached.

rustyfishbones · ‎2014-04-25

So you may need to sort by the Expression!!

Report Inappropriate Content · ‎2014-04-25

I would need output as in attached.

Report Inappropriate Content · ‎2014-04-25

Easiest way in the backend create a sort order and map it to the table with that field in, then just sort by the newly created field

Report Inappropriate Content · ‎2014-04-25

Thanks any example please?

Report Inappropriate Content · ‎2014-04-25

Thanks. Tried but it's not working. any solution please?

Report Inappropriate Content · ‎2014-04-25

Map1:

MAPPING LOAD * INLINE [

FieldIWantToSortPossibleValues,SortOrder

1 Month,1

2 Month,2

];

LOAD FieldIwantToSort,

ApplyMap('Map1',FieldIWantToSort,999) AS SortOrder

.

FROM ...

Sort via expression on chart and input =SortOrder

SunilChauhan · ‎2014-04-25

in sort expression

use

wildmatch(AgeSummaryMarch, null())

or use ' ' in place of null() in above exp

and use ascending or descendeing and see result

Sunil Chauhan

Report Inappropriate Content · ‎2014-04-25

when I am executing this it is showing a error as path specified can not found

how to replace NULL value as top most value in pivot table?