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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jorgett
Contributor III
Contributor III

Reverse Numeric Order

Hi All,

I have created a table and I calculated some values in one of the column. Now I want to put the calculated values in the following order, largest to smallest. Someone please help as I am new to qliksense.

Thanks,

JF

12 Replies
jorgett
Contributor III
Contributor III
Author

Hi Lorenzoconforti,

I am new to qlik sense so I was not aware of such tool. Do you know any good posts/articles that teach this concept and how to do it? 

Thanks,

JF

lorenzoconforti
Specialist II
Specialist II

Hi

R is a programming language that has been around for quite a while now that is used predominantly for statistical analysis. It can be integrated with Qlik Sense where data is passed from Sense to R that performs the calculations in the background and provides results back to Sense for visualisation. It's very powerful but you will need to understand how to code in R and how to manage the integration. 

Integration overview: https://support.qlik.com/articles/000039436

Info on R: https://en.wikipedia.org/wiki/R_(programming_language)

Then if you search the forum you'll find some info. 

It's feasible but if you are new to it there is a certain learning curve. At the same time I couldn't think of a solution to calculating your KPI so my only (although complex) suggestion would be to use R

jorgett
Contributor III
Contributor III
Author

Hi Lorenzoconforti,

Thank you for the information, I appreciate it. I do not have admin rights, I cannot access the QMC, but I have put in a request with my workplace helpdesk to see if they will do the integration for me. Meanwhile, I will try to find a way to solve this within qlik sense. Thank you once again.

Best,

JF