Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Contributor III

KPI's channel wise..Target Vs Actuals in Different Tab's Required..few additions in application


The application is working vary nicely

but, few more things I am required in the same application so it will become more helpful...can you help in it..

1) Can I get Channel wise Target Vs Actuals in a graphs in a separate sheet say Dashboard...where I will select channels available i.e. like Banka, Alternate, Direct..etc. and then I will select the KPI's available and accordingly month wise graphs generate...I have tried it but I am not get any out-put...also in second graph or if possible in same graph..If I select Two or more channels and KPI's then comparative graphs get generate..

2) In earlier sheet their are Three more columns which I forgot to give i.e. Total Target, Total Actuals and Measures..what happened is when I execute the application Only Two additional columns are get exported i.e. Total Target at the last and Measures at the same position. But Total  Actual columns not get exported...also I want excel sheet should get exported in the same order of rows and columns..what I observed is Gross Premium is at the top but Net Premium moved down also Total columns are moved at the end...

3)  Can I also get the Actuals figs. highlighted in green if Actuals are grater than Target and if not then it is in Red.

4) In pivot how I can get the scrolling option, as Pivot is currently fettling to the screen because of more KPI's and I can not scroll to know the last KPI result.

for reference I am attaching a new excel as well as Application..after including three additional columns.

KPI's channel wise..Target Vs Actuals in Different Tab's Required

Thanks in advance