topic Re: Date issue in QlikView

Date issue

upaliwije — Mon, 05 Jun 2017 09:38:30 GMT

I have developed a QV doc which I have attached herewith. There are 3 records relating to 3 different dates for the Months of May & Jun 2017. But I select a particular month the expected results are not show eg When I Select month of May the following appear.

But two records relating to month of may should display. Pls check my QV doc and help to correct it

Re: Date issue

kamal_sanguri — Mon, 05 Jun 2017 09:43:44 GMT

There are chances that the records which are not visible in chart may not have correct date format. Please use this script to change and ensure that you have all the items in correct date format.

Date(PROV_DATE,'MM/DD/YYYY hh:mm:ss TT') as PROV_DATE

Re: Date issue

vinieme12 — Mon, 05 Jun 2017 09:57:01 GMT

Do not use a Timestamp to create a MasterCalendar ; always only keep the date component

Modify the field to only keep date

Date(Floor(PROV_DATE),'MM/DD/YYYY') as PROV_DATE