Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

vikasmahajan
Honored Contributor III

help required for set analysis

Dear all

I have attached screen short for my report requirement is that when i Select  May/Jun 2012 month for current Financial year  then in last year I have show May/jun 2011.

How we have to write set analysis.

Thanks in advance

Vikas

Please note  my variables is  GROSS SALES AMT  and fiscalyear  and month no

1 Reply
jonbrough
Valued Contributor

Re: help required for set analysis

Do you need something like:

sum({<Year={'$(=Min(Year)-1'},Month={'$(=Min(Month)'}>} [GROSS SALES AMOUNT])

Jonathan

Community Browser