problem with a chart (set analysis)

[adiarnon]

hi,

i have a bar chart with a dimension of month_sales

i have a mesaure of purchase that conect to a dimention of month_purchase

my chart dimention is month_sales and and the expression is aum(sale_amnt)

but,

i want to add a expression of sum(purchase_amnt)

but i need that the value where the month_sales dimension =11/2015

it will show the sum(purchase_amnt) where month_purchase=11/2015

* i dont want to change my schema

somthing like-

sum({Purcahse_MONTH={(Sale_Month)}>}SO_Purchase) ??????

how can i do it?

hope im clear

[sasikanth]

Hi,

Try some thing like this

sum({Purcahse_MONTH=p({<month_sales ={'11/2015'}>}month_sales )  >}SO_Purchase)

[adiarnon]

not working

[adiarnon]

not working

[adiarnon]

i cant chnge my schema

[adiarnon]

not working

[adiarnon]

i dont understand the solution

[swuehl]

I don't think that set analysis will solve your issue.

But instead of repeating 'not working', I would try to add more information about your data model, best by uploading some sample data or a small sample QVW.

Adding a small data island in your model to create a common date dimension might also solve your issue, if you don't want to use the canonical date linked to your data. But this will also imply a change to the model and I understood that you don't want to do this (but haven't understood why).

[sfatoux72]

Sorry, I just saw that Sales_Month is a dimension of your chart. You couldn't use set analysis in this case, because set analysis is calculated outside the graph.

Try this:

sum(if(Purcahse_MONTH = Sale_Month, SO_Purchase))

I use your original formula for the name of the field.

--> Warning :

•      Typo in "Purcahse_MONTH"

[adiarnon]

i dont have access from my developer computer to the web so i cant upload a qvw

[awhitfield]

Then copy it to another Pc that you have got web access on

Andy