Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

set analysis

I have a requirement that need to get current year values for previous year sales executives only

how to get it by set analysis?

3 Replies
anandathome
Contributor

Re: set analysis

Could you give an example.

What fields are there to identify previous year sales executives?

Please post a sample application.

Re: set analysis

Could you please explain your requirements? if possible, please some sample data or file for better understanding.

MVP
MVP

Re: set analysis

Hi,

Try like this using P() in set analysis

=Sum({<Year={$(=Year(Today()))}, SalesExecutive=P({1<Year={$(=(Year(Today()) - 1))}>})>}  Sales)

Regards,

Jagan.

Community Browser