Calculate sum of Actuals M1, M2 and M3 when multiple Quarters selected

[#1]

Hi qlikviewers,

i'm in need of help and i think only here i am able to get the solution, so thanks in advance for all the help you might give.

im in the process of creating a Table, where i have PArtner name and then Target, Actuals of M1 M2 and M3.

the problem is when sales people press multiple quarters the M1 formula doesnt understand that we need the Sum of M1 of all the quarters selected.

thank you for all the possible help,

[abeyphilip]

Hi,

Can you post a sample qvw?

If it is a simple sum(m1), then it should consider the data for all the selected quarters (assuming you have master calender and M1 is linked to the quarter).

Or is it possible that you are ignoring quarter selection in set analysis?

Regards,

Abey

[#3]

hi Abbey,

we dont have in place a master calendar, but its possible that can be the solution.

sorry i dont have a qvw with a small size, its really big, but here the expression we were using:

=sum({<MetricName={'Ref Net Sellout for Quota Perf CLC'},Month={'$(vmonth1)'},Partnertype={'Resellers'}>}Value)

the vmonth1 variable contains the First month of the selected quarter, and the next step we need is to when select multiple quarters that it SUMS the M1 of all the quarters selected.

what do you think it would be the best solution for this?

thank again,

Br,

Julio & Shashi

[abeyphilip]

Hi,

How the value for vmonth1 is set?

Is it based on selection like - if FY13, Q1 is selected it will have a value - 201304 (April).

If yes, for multiple quarter selection, will have all the quarter values appended into that string as the value for vmonth1. something like 20130407 (April and July) and it wont find any value for the same.

regards,

Abey