Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator II
Creator II

% of total

Good morning,

i've got this situation.

I would like to get the % of Valore/total Valore for every year.

if i do --> sum(VALORE)/sum(total VALORE) it gives the % not for year but for all the table...

What do i need to set?

Thanks

Carlaf_93_0-1691047227526.png

 

Labels (1)
  • Chart

3 Replies
vamshi2i
Contributor II
Contributor II

Hi Carlaf_93,

Try this: 

sum({<Year>} VALORE) / sum(total <Year> VALORE)

Carlaf_93
Creator II
Creator II
Author

Thanks,

 

but this desn't work

 

Carlaf_93_0-1691048699114.png

 

Carlaf_93
Creator II
Creator II
Author

Sum({<[DATA.autoCalendar.Year]>}VALORE)/
Sum(total {<[DATA.autoCalendar.Year]>}VALORE)