Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
bharatkishore
Contributor III

where clause issue

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

1 Solution

Accepted Solutions

Re: where clause issue

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

5 Replies

Re: where clause issue

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

Re: where clause issue

Hi,

     YearMonth column is in what format?

bharatkishore
Contributor III

Re: where clause issue

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

Re: where clause issue

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
Contributor III

Re: where clause issue

Ohh ok. Thank you Sunny Bhai..