topic Re: Pivot table YoY change / amount in QlikView

Pivot table YoY change / amount

Anonymous — Thu, 20 Dec 2018 09:41:05 GMT

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 — Thu, 20 Dec 2018 10:48:32 GMT

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 — Fri, 21 Dec 2018 04:54:30 GMT

Thanks KC! It's working fine now

jyothish8807 — Fri, 21 Dec 2018 06:22:02 GMT

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

Have a great day.

Anonymous — Fri, 21 Dec 2018 06:32:50 GMT

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.