Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current Year vs Last Year

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

3 Replies
abeyphilip
Creator II
Creator II

Using Set analysis.

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

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

Regards,

Abey

jagan
MVP
MVP

Hi,

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

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


Regards,

Jagan.

Not applicable
Author

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