SET ANALYSIS help

[#1]

I want to compare two year sales, at the same month and same date

ex.

count number of sold items in november this year and compare with sold items sold at the same time last year.

As we have 11. november I want to count number of sold items in november this year = 11 days and

compare with the same amount of days last year i november.

I´ve tried with some help from another thread with something like this

({<year={$(vPreviousYear)},month={$(vMaxMonth)}, day={$(vLastMaxDate)}, itemgroup={75211}>}itemnr)

but this doent work

[ali_hijazi]

ignore selection inside your set analysis on year and month

Year=,Month=

count({<year=,month=, year={"$(vPreviousYear)"},month={"$(vMaxMonth)"}, day={"$(vDay)"}, itemgroup={75211}>}itemnr)

[#3]

Ali

what do you mean by ignore??

[#4]

ignore is nothing but irrespective selections of any month (month=;)

[#5]

Hi Ali

I was a little hasty - I see your expression but this gives me only the count for today()

I want to count for each day in november upto the 11. and the same fore last year

I tried with your example but I dont get the result I want

[mehmet_caldak]

Hi,

your current Set Expression consider just last year today, if you want to calculate for last year month to day you should use the expression below;

({<year={$(vPreviousYear)},month={$(vMaxMonth)}, day ={'<=$(vLastMaxDate)'}, itemgroup={75211}>}itemnr)

[ali_hijazi]

then remove the condition on day

count({<year=,month=, year={"$(vPreviousYear)"},month={"$(vMaxMonth)"}, itemgroup={75211}>}itemnr)

[#8]

Hi Ali

If i remove the DAY condition I will count all the items sold in whole november last year, so I cant compare with the amount of days in november this year which is only 11 days

[ali_hijazi]

then add the Year and Month, and day as dimensions to your chart and you can drag the dimension on chart to see values of each day near the day of Nov of last year

[#10]

go for comaparative analysis if not possible in expression