Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Rfoot
Contributor III
Contributor III

Sum values by column

Hi,

 

A simple question:

I want to sum all values for 2023/2024 YTD Actual by the MngReport Description.

So if MngReport Description is income then sum all corresponding values in the 2023/2024 YTD Actual.

Rfoot_0-1698696952876.png

Thank you.

 

Regards,

Ryan

 

Labels (2)
2 Solutions

Accepted Solutions
Lisa_P
Employee
Employee

{<[MngReport Description]={Income}>}Sum([2023/2024 YTD Actual])

View solution in original post

MayilVahanan

Hi

Try like below

Sum({<[MngReport Description]={'Income'}>}[2023/2024 YTD Actual])

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
Lisa_P
Employee
Employee

{<[MngReport Description]={Income}>}Sum([2023/2024 YTD Actual])

MayilVahanan

Hi

Try like below

Sum({<[MngReport Description]={'Income'}>}[2023/2024 YTD Actual])

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.