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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivvl0
Creator III
Creator III

How to find part (%) of the month sum from all year sum in group (Cycle) ?

hi ,

i have group with year->month , when i drill to month level i need to see for each month the relative part of the whole year ,for example , if i have at the year level the values :

y2017.PNG

and drill to month level , Expect see for each month the relative part (%) of the whole year (2017) :

pct2017.PNG

according to the months values :

m2017.PNG

BUT instead i see for each month the relative part of the whole ALL YEARS from 1997 ...    :

pct all years.PNG

I know that its because i am using TOTAL in the expresion :

sumA_VALUE ) /  sum ( TOTAL <A_YEARA_VALUE  ) * 100 


does anybody know the right way to solve this problem  ?  THANKS

12 Replies
yanivvl0
Creator III
Creator III
Author

here some data.

sunny_talwar

May be this

=If($(vGroup) = 'year', Sum(value), Aggr(Sum(value)/Sum(TOTAL <year> value) * 100, year, year_month_desc))

Where vGroup is GetCurrentField([Group])

yanivvl0
Creator III
Creator III
Author

HI Sunny , big help !!   as always - thanks