topic Re: Want to exclude Year'2017' in the Qlikview in QlikView

Want to exclude Year'2017' in the Qlikview

arunqlik2view — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Want to exclude Year'2017' in the Qlikview

PrashantSangle — Wed, 26 Dec 2018 09:36:04 GMT

Hi,

can you share screens shot of your work??

Regards,

Re: Want to exclude Year'2017' in the Qlikview

arunqlik2view — Wed, 26 Dec 2018 09:44:18 GMT

Re: Want to exclude Year'2017' in the Qlikview

ruma_barman — Wed, 26 Dec 2018 10:08:40 GMT

Remove single inverted commas and check

Re: Want to exclude Year'2017' in the Qlikview

Somasundaram — Wed, 26 Dec 2018 10:27:00 GMT

Try this,

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

Re: Want to exclude Year'2017' in the Qlikview

PrashantSangle — Wed, 26 Dec 2018 10:44:11 GMT

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,

Re: Want to exclude Year'2017' in the Qlikview

arunqlik2view — Wed, 26 Dec 2018 11:54:00 GMT

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

Re: Want to exclude Year'2017' in the Qlikview

arunqlik2view — Wed, 26 Dec 2018 11:55:19 GMT

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

Re: Want to exclude Year'2017' in the Qlikview

sunny_talwar — Wed, 26 Dec 2018 12:15:49 GMT

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

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