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

Sort by expression in pivot not working

Hi,

I have a IS report and a row ID so that the report will have the same order and it works good when the I have values in the month column (the first column in attached picture). But when as in the exampel I have 0 it will turn upp in the top of the report. I dont understand that ?

I have the row ID as an expressen : num(row_ID)

Could i write the exrpession in a different way ?  Regards mikael

1 Reply
Qvmaster2019
Creator
Creator

Hi mikael_hyensjo,

Could you attached your working file for this one?