topic Re: Specific Date in QlikView

Specific Date

evansabres — Tue, 21 Feb 2017 18:53:13 GMT

I have a field called nwEVENTDTE

I am creating a chart (straight table) using nwEVENTDTE as the dimension. I want to limit the dates that appear.

I only want to display nwEVENTDTE from 10/13/2016 through 4/5/2017.

I can't seem to get the structure of the calculated dimension correct. I am using

=if(nwEVENTDTE >='10/13/2016 <= 4/5/2017', nwEVENTDTE)

however this still displays dates before 10/13/2016.

sunny_talwar — Tue, 21 Feb 2017 19:00:38 GMT

May be this

=if(nwEVENTDTE >= MakeDate(2016, 13, 10) and nwEVENTDTE <= MakeDate(2017, 5, 4), nwEVENTDTE)

sunny_talwar — Tue, 21 Feb 2017 19:00:50 GMT

Or this

=if(nwEVENTDTE >='10/13/2016 and nwEVENTDTE <= 4/5/2017', nwEVENTDTE)

evansabres — Tue, 21 Feb 2017 19:02:46 GMT

I used this however still was not working. I added a ' after initial date and before secondary date and it worked

=if(nwEVENTDTE >='10/13/2016' and nwEVENTDTE <= '4/5/2017', nwEVENTDTE)