Current Year vs Last Year

[#1]

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

[abeyphilip]

Using Set analysis.

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

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

Regards,

Abey

[jagan]

Hi,

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

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

Regards,

Jagan.

[#4]

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)}>}