topic Re: pivot table problem in QlikView

pivot table problem

Thu, 17 Sep 2015 12:24:35 GMT

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.

Re: pivot table problem

mohamed_ahid — Thu, 17 Sep 2015 12:56:24 GMT

hi,

set analysis .

can you send a sample file ?

Re: pivot table problem

Thu, 17 Sep 2015 13:27:02 GMT

Hi Mohamed,

i used the following set analysis expression for testing

sum({1<Année={'2013'}>}[Evolution. Montant_Invest_fin]*[Evolution. TxParticipation])

it worked well in a text object but it didn't work when i put in the pivot table

Re: pivot table problem

mohamed_ahid — Thu, 17 Sep 2015 14:01:40 GMT

pourquoi tu fixe l'année à 2013 ?

tu utilise un calendrier non ? sur ton application tu as un selecteur de date ?

Re: pivot table problem

Thu, 17 Sep 2015 14:09:38 GMT

wi juste pour tester si ça marche j’utilise une fontion générique