Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mkb_Qlik
Contributor III
Contributor III

Qlik Pivot Table - Yearly Sum column

Hello,

I have table like below,

muthukumarbalu91_0-1597309437720.png

 

I wish to introduce a new column which shows yearly sum.

e.g  First Column 2019 which is sum of particular 2019 year data & Second column 2020 which is sum of particular 2020 year data

Followed by current monthly breakdown.

 

How to achieve this , Kindly suggest.

 

Thanks in advance!

Labels (1)
1 Solution

Accepted Solutions
Ksrinivasan
Specialist
Specialist

hi,

Ksrinivasan_0-1597344730599.pngKsrinivasan_1-1597344773551.png

Sum({$<Period = {"*2019*"}>}Sales),

or 

add one more table resident with Year,

then add into period with value in Master table 

then it will display as you expected,

View solution in original post

2 Replies
Ksrinivasan
Specialist
Specialist

hi,

Ksrinivasan_0-1597344730599.pngKsrinivasan_1-1597344773551.png

Sum({$<Period = {"*2019*"}>}Sales),

or 

add one more table resident with Year,

then add into period with value in Master table 

then it will display as you expected,

mkb_Qlik
Contributor III
Contributor III
Author

Thanks @Ksrinivasan , For your reply.

However i have completed this request with creating Data island with relevant Measure names and Handled the scenario in Measure with If condition. PFB.

muthukumarbalu91_0-1597381394477.png

Thank you very much for your assitance!