Discussion Board for collaboration related to QlikView App Development.
i have the below code:
(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..
Go to Solution.
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);
YearMonth column is in what format?
Thank you sunny bhai it worked.. can you please tell me is it because of string it did not get executed..
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.
Ohh ok. Thank you Sunny Bhai..