topic Re: set analysis - pulling last years data with a variable in QlikView

set analysis - pulling last years data with a variable

Wed, 25 Nov 2020 16:16:04 GMT

Just trying to get some data using set analysis but running into a problem

I have a few buttons at the top where i can set the year i'm interested in

and putting this expression in

=count({$<RegYear={$(v_year)}>} distinct person_id)

works fine regardless of the year I select. e.g. 2016, 2015, 2014 , all bring back data

when i add a 2nd expression which tries to pull the previous years data using the expression

=count({$<RegYear = {$(v_year - 1) }>} distinct person_id)

the output is just a row of 0's

Can anyone spot any issues with this 2nd formulas please

sushil353 — Fri, 08 Jul 2016 10:32:27 GMT

Try this:

=count(distinct {$<RegYear = {'$(v_year)-1 '}>} person_id)

HTH

antoniotiman — Fri, 08 Jul 2016 10:41:32 GMT

Try

=count({$<RegYear = {$(=$(v_year) - 1) }>} distinct person_id)

Fri, 08 Jul 2016 11:26:45 GMT

Thank you Antonio, works perfect