Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Compare this year sales to last year

hi,

how to get and compare particular two years sales of customers.

how to add a field which contains the past year and present year netsales.

1 Reply
Not applicable

Compare this year sales to last year

Use Set Analysis someting like for this year

Sum({1 <Year=Year(today())>},Sales)

and for last year

Sum({1} <Year = Year(today())-1},Sales)

Community Browser