topic Re: where clause issue in QlikView

where clause issue

bharatkishore — Wed, 16 May 2018 11:29:41 GMT

Hi All,

i have the below code:

LOAD Plant,

Part_Type,

Contract_Type,

BUEqui,

Country,

Strategic_Flag,

YearMonth,

Fiscal_Month,

Calendar_Year,

ITM_Consumption,

ITM_IB,

YTD_Consumption,

YTD_IB,

YTD_Consumption_LY,

YTD_IB_LY,

ADJ_CONS_YTD_LY,

Country_CR,

Country_Final_temp,

Country_Final

FROM

[\..\T1.qvd]

(qvd) where YearMonth = '201712';

when i give this where clause i am getting 0 records and when i remove the where condition i am getting the output..

Can you please tell me where i am doing wrong..

Thanks,

Bharat

sunny_talwar — Wed, 16 May 2018 11:31:24 GMT

How is YearMonth created in the qvd file? May be it is a date field rather than string... try this

Where YearMonth = MakeDate(2017, 12);

keerthika — Wed, 16 May 2018 11:34:50 GMT

Hi,

YearMonth column is in what format?

bharatkishore — Wed, 16 May 2018 12:41:49 GMT

Thank you sunny bhai it worked.. can you please tell me is it because of string it did not get executed..

sunny_talwar — Wed, 16 May 2018 12:43:06 GMT

No, you MonthYear field is a actual date field and you were comparing it to a number. Using MakeDate(), we created a date to compare the date field.

bharatkishore — Wed, 16 May 2018 12:45:21 GMT

Ohh ok. Thank you Sunny Bhai..