Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Search may be unavailable 11:30 PM on Aug 24 to 1:30 AM on Aug 25. Thank you for your patience.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
QVUser1
Partner - Contributor III
Partner - Contributor III
‎2021-09-15 02:41 AM

KPI Value - Grouping Issue

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

QVUser1_0-1631687992020.png

 

763 Views
0 Likes
1 Reply
vikasmahajan
MVP
MVP
‎2021-09-16 09:04 AM

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.
722 Views
0 Likes