topic Re: Qlik Pivot Table - Yearly Sum column in App Development

Qlik Pivot Table - Yearly Sum column

mkb_Qlik — Sat, 16 Nov 2024 01:40:55 GMT

Hello,

I have table like below,

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!

Re: Qlik Pivot Table - Yearly Sum column

Ksrinivasan — Thu, 13 Aug 2020 18:56:58 GMT

hi,

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

add one more table resident with Year,

then add into period with value in Master table

then it will display as you expected,

Re: Qlik Pivot Table - Yearly Sum column

mkb_Qlik — Fri, 14 Aug 2020 05:04:28 GMT

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.

Thank you very much for your assitance!