only expression not working..

[cafcptg2011]

Hi,

I need to to know client that has only SalesDate=StoreDate but hasn't sales in another date, How can I exclude the clients with more then one sales.

my data:

I need to obtain a pivot table with :

Store | Cliente

A | 2

B | 5

my currente expression is : only({<SalesDate={$(=Date(StoreDate))}>} Client) but doesn't work! 😞

my qvw is here http://community.qlik.com/servlet/JiveServlet/downloadBody/7918-102-1-10720/TesteOnly3.qvw

Could someone help me please,

thanks in advance,

CAFC

[cafcptg2011]

thank you very much... your approach is acceptable...i would prefer not alter the load script....but your solution works ..that it is the most important...again thank you very much for help...

[cafcptg2011]

sorry...but your solution doesn't work in pivot table..

thanks anyway

[cafcptg2011]

I'm sorry.. but can't agree with you...I have explained correctly what i needed...

but anyway thank you very much for your effort.

regards,