Issue with do/loop and date field

markthepig — Tue, 11 Dec 2012 15:10:22 GMT

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

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');

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

topic Issue with do/loop and date field in QlikView