KPI Value - Grouping Issue - Qlik Community

QVUser1 · ‎2021-09-15

Hi All,

I need a KPI value which is coming correct on Aggregate on 3 dimensions(Country, Date, Emplyoee Name) .

As i am dealing with huge data and in my dashboards i have 11 dimensions as filters and this KPI value should change based on other 11 dimensions if you write in front end its working fine.

But if try to do it in backend the KPI values changes because as we are aggregating this KPI value based on

(Country, Date, Emplyoee Name + 11 Other Dimensions )

Need this output in backend Script : already distinct is used

vikasmahajan · ‎2021-09-16

Hi,

Please go through this https://www.analyticsvidhya.com/blog/2014/02/aggr/

very good explained here.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.