topic Where in QlikView

Where

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

Hi All,

Iam using the below condition in the script using where condition ..

Where (Pass_Year= Year(Today()) and Passmonth <= 12) AND (Pass_Year = Year(Today())-1 and Passmonth > 12);

This is giving me error..Please let me know if this is correct or needs to be changed ..

Thanks

Re: Where

tamilarasu — Thu, 14 Dec 2017 08:05:18 GMT

Hi John,

The where clause looks fine. What is the error message?

Re: Where

smilingjohn — Thu, 14 Dec 2017 08:08:16 GMT

Hi Nagaraj

Thanks for the reply ..when I reload this I get a error like

Unexpected expression error ')..

Iam confused with this

Re: Where

ali_hijazi — Thu, 14 Dec 2017 08:09:55 GMT

Pass_Year cannot be at the same time Year(Today()) and Year(Today())-1

your condition should be

Where (Pass_Year= Year(Today()) and Passmonth <= 12) OR (Pass_Year = Year(Today())-1 and Passmonth > 12);

One thing to note the Month cannot be greater than 12!!

Re: Where

vineetadahiya12 — Thu, 14 Dec 2017 08:11:52 GMT

This condition seems working fine when I tried with some dummy data. Can you share you sample that would make it easy to debug .

Re: Where

vineetadahiya12 — Thu, 14 Dec 2017 08:12:54 GMT

The condition is fine seems the issue is in some other part of script

Re: Where

tamilarasu — Thu, 14 Dec 2017 08:33:19 GMT

Hi John,

I think the issue is not because of the where condition but some other part. Could you please post your script here.

Re: Where

smilingjohn — Thu, 14 Dec 2017 08:36:38 GMT

HI Nagaraj.

My full where condition is below

where (Pass_year = Year(Today()) and passmonth <= 12) or (Pass_year = Year(Today())-1 and passmonth > 12)

and [Discription_Date] < if(WeekDay(today()) = 'Fri',today() - 3,

if(WeekDay(today()) = 'Sun', today() - 2,

today() - 1));

and the error is like missing field '<= >

Re: Where

tamilarasu — Thu, 14 Dec 2017 08:45:16 GMT

John,

The above where condition is also looks fine to me . It looks like you have problem in passmonth field. Can you please check your passmonth field? Also If possible please share complete load statement.?

Re: Where

Anil_Babu_Samineni — Thu, 14 Dec 2017 08:48:34 GMT

I believe you need this?

where ((Pass_year = Year(Today()) and passmonth <= 12) or (Pass_year = Year(Today())-1 and passmonth > 12))

and ([Discription_Date] < if(WeekDay(today()) = 'Fri',today() - 3, if(WeekDay(today()) = 'Sun', today() - 2, today() - 1)));

Re: Where

vineetadahiya12 — Thu, 14 Dec 2017 08:50:30 GMT

This again seems working fine. John, Can you please share the sample file with us or the complete load stmt.