topic Re: Previous Year Same month Set Analysis in QlikView

Previous Year Same month Set Analysis

Sun, 23 Jun 2013 12:25:23 GMT

Hi All,

I want to take the sum of previous year same month based on my month selection. For that i wrote like this below,

Sum

( {<Year=,
Month =,
SALES_DATE = {"$(=date(MonthName(AddMonths((max(SALES_DATE)), -12)),'YYYYMM')"}
>} Sales Cost

But its not working. What im doing wrong here.. My Sales date format is YYYYMM

Thanks,

Selva

Re: Previous Year Same month Set Analysis

swuehl — Sun, 23 Jun 2013 12:36:10 GMT

Please double check your closing brackets, it seems you missed the last closing one.

Then, you probably don't need the MonthName function at all, or why do you think you need it here?

Check that your get the correct result returned when using

=date(MonthName(AddMonths((max(SALES_DATE)), -12)),'YYYYMM')

in a text box.

Re: Previous Year Same month Set Analysis

Sun, 23 Jun 2013 12:49:02 GMT

Hi Swuehl,

Thanks for you reply. Initially i tried in Text box after that only i tried to implement the same in set Analysis. As you said MonthName is not required.

Still its not working for me in set analysis. Now my set is like this.

Sum

( {<Year=,
Month =,
SALES_DATE = {"$(=date((AddMonths((max(SALES_DATE)), -12)),'YYYYMM')"}
>} SALES_Cost )

Selva

Re: Previous Year Same month Set Analysis

swuehl — Sun, 23 Jun 2013 12:56:14 GMT

I do still count 6 opening '(' vs 5 closing brackets ')'... Check your syntax, add a closing bracket at the end of your search string.

Re: Previous Year Same month Set Analysis

Sun, 23 Jun 2013 13:11:07 GMT

Yes, its an mistake in syntax.. Thanks for your time Swuehl