topic Re: Calculate Years based on a base year in QlikView

Calculate Years based on a base year

tmumaw — Tue, 31 Oct 2017 18:30:33 GMT

I have this pivot table where I want to calculate percent of increase or decrease based on the first year (2013). Any ideas?

thanks

aarkay29 — Tue, 31 Oct 2017 19:21:07 GMT

try this

(

sum(OrganicClients)-Sum({1<FISYR={$(=Min({1}FISYR))}>}OrganicClients)

)

Sum({1<FISYR={$(=Min({1}FISYR))}>}OrganicClients)

sunny_talwar — Tue, 31 Oct 2017 23:55:45 GMT

May be this

Sum(Measure)/Sum(TOTAL <GM> {<FISYR = {"$(=Min(FISYR))"}>} Measure) - 1