Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist II

Help with Where

Hi ,

For some reason my clause WHERE doesn't work.

My code just ignore this clause as below

Code

vData=date(vData-dias);

NoConcatenate

Aux:

LOAD

OID_SYSTEM,

DATE_READ,

'$(vData)' AS TESTE

RESIDENT RS_INDIVIDUAL_READ

WHERE DATE_READ > FLOOR($(vData));

DROP TABLE RS_INDIVIDUAL_READ;


Output:


where.JPG

1 Solution

Accepted Solutions
sunny_talwar

May be try this

vData = Num(vData-dias);

NoConcatenate

Aux:

LOAD

OID_SYSTEM,

DATE_READ,

'$(vData)' AS TESTE

RESIDENT RS_INDIVIDUAL_READ

WHERE DATE_READ > FLOOR($(vData));

View solution in original post

4 Replies
sunny_talwar

May be try this

vData = Num(vData-dias);

NoConcatenate

Aux:

LOAD

OID_SYSTEM,

DATE_READ,

'$(vData)' AS TESTE

RESIDENT RS_INDIVIDUAL_READ

WHERE DATE_READ > FLOOR($(vData));

pradosh_thakur
Master II
Master II

why not use the floor in the variable itself and use the variable itself in the where condition ?

regards

Pradosh

Learning never stops.
eduardo_dimperio
Specialist II
Specialist II
Author

Hi Sunny, thanks again for your help friend, that works... i was so distract about visual output that i didn't think about data type.

eduardo_dimperio
Specialist II
Specialist II
Author

Hi Pradosh, thank you for your time, i tried this but withou result. The problem was with variable type.