Thank you for you answers i've tried both of your suggestions but with no luck. i'm not sure i'm doing it right.
my data is containing stores which can have products and the products can have different values and that value varies over time.
when i load all my qvd's without any adjustments mention above i get duplicates when using everyfield above exept value as dimension and then sum(value) as expression. this is how i do the testing. my main concern is in the chart where i'm having store as dimension and then in my expression i'm looking at a specific product where i want to show the latest value of that product.
Ah … I see your problem – so the products are duplicated, but because the value has changed over time each line is unique.
For the set analysis you’re using I think you’re missing a $-sign in the max bit. Try date={$(=max(date(date)))}>} and see if that helps. I’m pretty sure it needs a dollar-sign expansion …
Emma Self
Business Information Manager | Investment Property Management
9 Marylebone Lane | London W1U 1HL | United Kingdom
www.colliers.com/uk
<http://www.colliers.com/markets/uk/BCSC>
Confidentiality Notice: This communication and the information it contains: (a) is intended for the person(s) or Organisation(s) named above and for no other persons or organisations and, (b) may be confidential, legally privileged and protected by law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you receive this communication in error, please notify us immediately, destroy any copies and delete it from your computer system.
Please go through your SET Syntax part i thing some where it missing and also where ever you want to remove duplicates use Distinct. But some of the places they are not duplicate because some data is related with it so you need to check which fields are related with the duplicate fields in that case use aggregation for Count and Sum function.
