Reverse Numeric Order

[jorgett]

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

[jorgett]

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]

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]

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