explination?

[#1]

sum({$<PRODUCT ={$(=concat(‘”‘ & Product_ref & ‘”‘, ‘,’))}>} SALES) 

here i have product  and  product_ref  separate fields

product belonges to t1 table and    product_ref  belonges to  table t2.

to make relationship  between tl and t2 they have been used concat function   thats ok fine    but here

=concat(‘”‘ & Product_ref & ‘”‘, ‘,’))          what is use of this symbols '"' &product_ref &'"',','     pls give me explination about this

if i am selecting one product then next how it works?

[anbu1984]

If two tables are not linked, then selecting on Product wont affect the sum. Check the attached qvw.

Try uncomment this line and reload and check the results

//Load *,Product_ref as PRODUCT Inline [

[#3]

Hi Manoj,

could you please provide sample data for field [product_ref ]

=concat(‘”‘ & Product_ref & ‘”‘, ‘,’))  will return "product_ref",

[#4]

by using concat we can make relation ship right?

pls explain me above expression how it works ?

[#5]

Hi pfa

[anbu1984]

Relationship or links between tables can be made at script level.

sum({$<PRODUCT ={$(=concat(‘”‘ & Product_ref & ‘”‘, ‘,’))}>} SALES) is equivalent to sum({$<PRODUCT ={'a','b'}>} SALES).Instead of hard coding values, you are getting from a field(Product_ref)

[ashfaq_haseeb]

Hi,

Its a kind of indirect set Analysis.

The code

=concat(‘”‘ & Product_ref & ‘”‘, ‘,’) will give you o/p  ex: as 'AB200'

And hence you get sum for that particular Reference.

If you have any single selection in field Product_ref

Then your set expression is converted like this

=sum({$<PRODUCT ={AB200}>} SALES) 

Hope it helps

Regards

ASHFAQ

[#8]

Concate function  return aggregate string

=concat(‘”‘ & Product_ref & ‘”‘, ‘,’))

Product_ref  have values  A and B

then it will retun "A","B"

[#9]

what is the use of   '"'&  symbols here in the expresson

[ashfaq_haseeb]

To get Value like this

'AB200'

You can replace that with chr(39)

Regards

ASHFAQ