Dear community
I'm a beginner so this is something very simple ,but i cannot think of a way to do it right.
So. Let me explain what problem i have.
I have an excel document that have the following rows
| DATA | CatClient |
| 9/5/2012 | dune inc |
| 9/18/2012 | salso inc |
| 9/17/2012 | babmoo inc |
| 9/21/2012 | alcor ltrd |
| 9/19/2012 | sumo ltd |
| 9/26/2012 | elmo ltd |
| 8/31/2012 | dreasos ltd |
| 8/31/2012 | G&Galtor |
| 9/30/2012 | LIPEST COM |
| 9/21/2012 | MACSL COM |
| 8/31/2012 | NXCO DISTRL COM |
| 10/11/2012 | OFFIL COM |
| 9/5/2012 | PROSA COM |
| 9/22/2012 | PRMLAC COM |
| 9/20/2012 | SERSCOM |
| 10/25/2012 | TERCT COM |
| 9/12/2012 | COMBI COMIMPEX SRL -COM |
my qlikview script
xcel:
LOAD
rowno() as row,
DATA,
CatClient
FROM c:\!\data.xls (biff, embedded labels, table is [Sheet1$]); (,<- this is the excel above)
let RO = peek('Rand');
do
let cat = fieldvalue('CatClient',$(RO));
let dta = fieldvalue('DATA',$(RO));
Base:
LOAD
CodProd,
Data,
Tip,
Pice,
qty,
CateClienti
FROM c:\!\Base.qvd (qvd) where CateClienti = '$(cat)' and DATA >= '$(dta)' ';
let RO = RO - 1;
loop while $(RO) > 0
drop table xcel;
For the clients that have same dates (it only works for the firs one). I'm talking about the ones from the excel file.
ex:8/31/2012 dreasos ltd (it takes in consideration (where CateClienti = '$(cat)' and DATA >= '$(dta)' ';)
but for the rest G&Galtor and NXCO DISTRL COM (takes in consideration only CateClienti = '$(cat)' but not the date)
The issues is clearly with the dates being the same. But i cannot understand why.
Hope i explain my issues to your understanding.
Thank you for taking time to read my post.
Yours
mark
