topic where condition in QlikView

where condition

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using below sript and fetching the data from Data base

it executes the script with error saying doesn't match the where condition

error msesage

Literal does not match format string

where "ServiceDate">'43118'

Please someone can suggest me how do i write the wehere condition . here

Load

ServiceDate,

Dept,

Text(Item) as Item_Key ,

Product,

State

SQL SELECT

* FROM "DTS_IP".Fact

Where ServiceDate > '$(vLast_Update_Date)';

Need help

Thanks in advance

Re: where condition

shiveshsingh — Tue, 24 Apr 2018 07:04:38 GMT

Try this

Load

ServiceDate,

Dept,

Text(Item) as Item_Key ,

Product,

State;

SQL SELECT

ServiceDate,

Dept,

Item,

Product

FROM "DTS_IP".Fact

Where ServiceDate > '$(vLast_Update_Date)';

Re: where condition

olivierrobin — Tue, 24 Apr 2018 07:05:15 GMT

hello

as usual with dates, you have to take care or the format or date fields

be sure that your field and the content of the variable have same date format

Re: where condition

smilingjohn — Tue, 24 Apr 2018 07:16:16 GMT

HI Shivesh ,

Thanks for the reply it says

Literal does not match format string

where "ServiceDate">'43118'

Re: where condition

smilingjohn — Tue, 24 Apr 2018 07:22:25 GMT

Hi Robin,

The date format is same it is giving the below error message during the reload process as

Literal does not match format string

where "ServiceDate">'43118'

thanks

Re: where condition

smilingjohn — Tue, 24 Apr 2018 07:52:00 GMT

Hi Robin

Yes you are correct it is issue with the date format

Thanks

Re: where condition

shiveshsingh — Tue, 24 Apr 2018 09:58:18 GMT

Then you need to check the format of the date