Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

27 Replies
Not applicable
Author

Thanks. what is input order means Is it load order? under sort tab?

antoniotiman
Master III
Master III

Try to use Rank function in Order Section

Not applicable
Author

Sorry I confused here. where is the order section? Is it Sort tab in pivot table?

antoniotiman
Master III
Master III

Sorry (Italian is Order), Sort section of Document.

Not applicable
Author

Thanks. How to use Rank function?

antoniotiman
Master III
Master III

Rank(Sum(Sales)) or Rank(Count(Customer)) etc.

for parameters  as Rank(sum(Sales),4) see Guide.

eduardo_sommer
Partner - Specialist
Partner - Specialist

Yes. It's the Sort tab. Move AgeSummary_March to the top of the list and choose Load Order.

Not applicable
Author

Thanks. Perfect