topic Re: Current Year vs Last Year in QlikView

Current Year vs Last Year

Wed, 25 Sep 2013 06:50:17 GMT

Hi. How can i display all the clients that bought from us this year, but didn't buy the last year.

abeyphilip — Wed, 25 Sep 2013 06:55:28 GMT

Using Set analysis.

If you have a year field mention specifically this year. Something like below:

Year={$(=year(today()))}

Regards,

Abey

jagan — Wed, 25 Sep 2013 07:00:24 GMT

Hi,

Check E() in Qlikview help file in Set Analysis section

=sum( {$<Customer = E({1<Year={$(=Year(Today())-1)}>} Customer) >} Sales )

Regards,

Jagan.

Wed, 25 Sep 2013 07:05:13 GMT

try this,

For Max Year Calculation

create one variable like

vMaxYear=max(year(date(Datfield,'DD/MM/YYYY')))

use above variable in setanalysis like

{<Datefield={$(vMaxYear)}>}