Want to exclude Year'2017' in the Qlikview

[arunqlik2view]

Hello Qlikview Experts,

I'm trying to not show any dates for the year 2017. I did try the  syntax in the Qlikview Editor as per the instruction in the previous blog - https://community.qlik.com/t5/New-to-QlikView/How-to-exclude-unwanted-year-in-Date-field/m-p/839470 

But , it doesn't seem to work for me . 

The syntax I tried from that Blog is Where Year(Relevant_Date) <> 2017;

Please let me know what am I doing wrong here. 

Thanks & Regards,

Arun 

[PrashantSangle]

Hi, 

can you share screens shot of your work??

Regards,

[arunqlik2view]

[ruma_barman]

Remove single inverted commas and check

[Somasundaram]

Try this,

SQL SELECT *
FROM ABCDB.TTTEX_SEGMENT_WISE_DAILY_REVENUE
where Year(Relevany Date) <>'2017';

[PrashantSangle]

Hi Arun,

Your where clause is detecting in attached script. It is mainly because of back quotes `

remove that back quote which you applied before and after TTTEX_SEGMENT_WISE_DAILY_REVENUE this field

Regards,

[arunqlik2view]

hi thanks for the reply, i tried didn't work

[arunqlik2view]

hi thanks for the reply, i tried didn't work

[sunny_talwar]

If this is connection to Oracle, then you can try this

WHERE TRUNC(RELEVANT_DATE, 'YEAR') <> '1JAN2017'