Filter condition in qliksense

[ksk278074]

Hi,

I am having one field like calender's year/month in this the date format is APR 2017,SEP 2017.........

now i have written the filter condition  like

where [calender's year/month] ='APR 2017'.

please suggest me if it is write or wrong,

If wrong how to writhe the correct expression with correct date format.

[arvind_patil]

Hi Sivakumar,

Please use wildmatch:

Where Wildmatch([calender's year/month],'APR 2017')

Thanks,

Arvind Patil

[ksk278074]

Thanks for the reply.

So the below condition is wrong?

where [calender's year/month] ='APR 2017'.

[OmarBenSalem]

Are u sure ur field contain APR 2017 value and not apr. 2017 ?

With a dot (.) after apr?

Because formating dates using : Date(MonthStart(YourDate),'MMM YYYY') would generally result into a month then a dot then the year

please see exactly how it has been written

[ksk278074]

Hi,

NO (.) Is there between the apr and 2017

it showing APR 2017.