Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
sorry...but your solution doesn't work in pivot table..
thanks anyway
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,