topic Re: set analysis not working for previous year in QlikView

set analysis not working for previous year

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 formula please

Anonymous — Fri, 08 Jul 2016 11:06:37 GMT

Try this..

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

sunny_talwar — Fri, 08 Jul 2016 11:28:27 GMT

Try this:

=Count({$<RegYear = {$(=$(v_year) - 1)}>} DISTINCT person_id)

sasiparupudi1 — Fri, 08 Jul 2016 11:39:59 GMT

=Sum({<RegYear={"$(=Max(RegYear)-1)"}>} DISTINCT person_id)