Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
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

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

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