Pivot table YoY change / amount

[Anonymous]

 Hi all, 

I am creating a pivot table to compare YoY for 2017 and 2018. Please refer to 'What i want.PNG' in the attachment.

What i want is how do i generate a pivot table (YoY % change and YoY amount) as shown in the attachment?

[jyothish8807]

Hi CHoy,

Below expressions should help you:

Exp1: sum({<Year={'$(=max(Year)-1)'}>}Sales        //2017 Sales

Exp2 :sum({<Year={'$(=max(Year))'}>}Sales        //2018 Sales

Exp 3: (sum({<Year={'$(=max(Year))'}>}Sales  -  sum({<Year={'$(=max(Year)-1)'}>}Sales))   / sum({<Year={'$(=max(Year)-1)'}>}Sales      //YoY % change

Exp4: sum({<Year={'$(=max(Year))'}>}Sales  -  sum({<Year={'$(=max(Year)-1)'}>}Sales  //YoY amount

[Anonymous]

Thanks KC! It's working fine now

[jyothish8807]

You are welcome 🙂 Please close the thread by marking the correct answer.

Have a great day.

[Anonymous]

Hi KC,

How do close the thread by marking the correct answer? I googled just now but couldn't find the "actions" button as shown below.

https://community.qlik.com/t5/New-to-QlikView/How-to-mark-Helpful-or-correct-reply/m-p/1334212