Qlik Sense and R integration: ggplot and other visualizations, aggregation and data sorting
I’ve been working with Qlik for the last four years and in the past few months I’ve been more and more involved into bringing R functionalities into my dashboards. The integration works well but there are clearly some limitations, especially when compared to other solutions on the market; Qlik in my opinion still has a significant edge in terms of performance and associative engine and, when combined with R, it brings unique functionalities and features.
The purpose of this document is to review such limitations and provide solutions with the aim of fully utilising all R capabilities in Qlik Sense; there are Qlik extensions that provide some of these features but, although very well developed and implemented, they are limited to the type of analysis they can perform; also, they require a certain level of technical skills to adapt them to the bespoke needs that very often arise when working with R.
These are the 3 topics I will cover in the document:
ggplot and other visualizations: how to easily and effectively display in Qlik Sense any kind of R visualization without the need to develop bespoke extensions
Data aggregation through concatenation: how using the aggregation function allows to pass to R more complex data frames
Data sorting: how data is exchanged between Qlik Sense and R and how to handle sorting
I hope you'll find this useful
Please let me know if you have any comment or questions