topic Re: Date field not working properly in QlikView

Date field not working properly

kishorj1982 — Tue, 10 Jul 2018 13:05:34 GMT

Hi All,

In my data model date format is different and it is not working fine.

I have attached sample data and transformations that we used.

Could you please suggest what kind of transformations do I need to apply.

Thank

sunny_talwar — Tue, 10 Jul 2018 13:11:26 GMT

Would you be able to share DimContract.QVD so that we are able to run your qvw

kishorj1982 — Tue, 10 Jul 2018 13:35:47 GMT

PFA.

Thanks

sunny_talwar — Tue, 10 Jul 2018 13:49:14 GMT

Check the attached and see if it make sense

kishorj1982 — Wed, 11 Jul 2018 04:02:20 GMT

Hi Sunny,

Thanks for the response.

But for end date it is not working fine.Could you please suggest on this.

Thanks

sunny_talwar — Wed, 11 Jul 2018 10:34:03 GMT

Have you tried applying the same logic I applied for start date for the end date