I need ti filter calculated measures in pivot table in Qlik Sense.
My new field is: =aggr(if(Sum({$<[Statistik.YEAR] ={"=$(=(year(today())))"}>} [Statistik.ARBEITSPREIS])
-
before(Sum({$<[Statistik.YEAR] ={"=$(=(year(today()))-1)"}>} [Statistik.ARBEITSPREIS]))>11,[Statistik.ARBEITSPREIS])
I need to create some filter where user can choose projects where the value bigger then 5 is.