Can you please suggest what is the main advantage of using R programming tool with qlikview.Which functionalities we can not do in any ETL or reporting tool and possible only by using language like R.
You can do very complex statistical calculations in R that are not possible with the standard Qlikview functions. Technically you could probably do everything in Qlikview, but you'd have to get very creative with javascript or vbscript macros. So, if you need to do advanced statistical calculations you'd be better off using R than Qlikview. It is possible to use R from Qlikview. See for example: QlikView and R Integration for Predictive Analytics Example
Generally we use R programming to do the statistical analysis. There are packages available in R to do the same. Advantage of using R programming with QlikView is that you can perform the statistical analysis in Qlikview itself instead going back to R studio as you have already QlikView in place. There are many resources available on community to connect QlikView with R.
