Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

previous values in pivot table

Hello ,

I'm using a pivot table in my recent application and i have a small problem , my table is the following ,


in the column AN-1 i want to have the value of the first expression for the previous year, i tried set analysis   ,it didn't work, i found out about the after() function , i worked well when no filters are applicated, but when i select one year the vaules for AN-1,AN-2 .. disappear.

is there any other solution ?

thanks in advance.