Set Analysis to display similar fields as one field'

[#1]

I am having  following tables

Fact:        

Brand Code,

Site_ID,

Sales

Site Brand Area:

Site_ID,

Site Brand Name,

Brand SQ.M.

Target:

Site_ID,

Site Brand Name,

Target/Sqm

Brand_Master:

Brand Code,

Brand

I would like to display, for Site_ID, Sales, and sum(Brand SQ.M.*Target/Sqm) where i want to use set analysis for Brand and Site Brand Name,

and I am using :

Sum(

{<[Brand] = {"=[Site Brand Name]=[Brand]"}>}

([Brand SQ.M.]*[Target/Sqm.])

cant work.

[preminqlik]

do one thing ... bring Brand code field for brand target table by applymap or left join ,

then concatenate brand target table with FACT on the bases of keeping the common field Brand Code 

[rajat2392]

Hi Vivian,

Try this script..

Sum(

{<[Brand] = {'$(=[Site Brand Name])'}>}

([Brand SQ.M.]*[Target/Sqm.])

)

[#4]

Hi,

Try this

Sum(

{<[Brand] =p( [Site Brand Name])>}

([Brand SQ.M.]*[Target/Sqm.])

)

Hope it may help....

[#5]

HI, Saranya,

It result in Total Target Amount. But not divided according to Brand.

Thank you

[rajat2392]

Hi Vivian,

Did you try this

Sum(

{<[Brand] = {'$(=[Site Brand Name])'}>}

([Brand SQ.M.]*[Target/Sqm.])

)

[rajat2392]

Can you provide you sample qvw please...

[#8]

Hi Vivan,

Try this expression with Aggr() like below:

sum(aggr(Sum(

{<[Brand] =p( [Site Brand Name])>}

([Brand SQ.M.]*[Target/Sqm.])

),[Brand]))

Hope it will help....

[#9]

HI Rajat.

thank you for your reply.

I have tried that before. It doesnt help me.

and I dont have sample data or qvw

thank you

[#10]

can u share your qvw file

tat will be easy to identify the prob.....