Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
eduardo_dimperi
Valued Contributor 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

Tags (1)
1 Solution

Accepted Solutions

Re: Help with Where

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

4 Replies

Re: Help with Where

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
Honored Contributor II

Re: Help with Where

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

regards

Pradosh

Learning never stops.
eduardo_dimperi
Valued Contributor II

Re: Help with Where

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_dimperi
Valued Contributor II

Re: Help with Where

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

Community Browser