topic Re: Issue with Date Field in QlikView

Issue with Date Field

Wed, 25 Nov 2020 16:16:04 GMT

Attaching the sample qvw. Want to change the date in the front end, as a conditional dimension.

Thanks for the help Sunny.

sunny_talwar — Mon, 10 Oct 2016 20:18:09 GMT

Conditional dimension or you meant calculated dimension? Try this

=Date(Date#(YR_MTH_KEY, 'YYYYMM'), 'MMM-YY')

Mon, 10 Oct 2016 21:06:03 GMT

I tried out your expression in the calculated dimension. This is what I got..:(

sunny_talwar — Mon, 10 Oct 2016 21:16:36 GMT

Can you post a screenshot of just YR_MTH_KEY?

Mon, 10 Oct 2016 21:20:46 GMT

sunny_talwar — Mon, 10 Oct 2016 22:00:41 GMT

I mean it works in the sample you have provided, right? I guess the only other things you can try this

=Date(Date#(Text(YR_MTH_KEY), 'YYYYMM'), 'MMM-YY')

MarcoWedel — Mon, 10 Oct 2016 23:53:00 GMT

it seems you are interpreting the underlying numerical value of an already dual loaded date field with the date#() interpretation function.

Try to just use the formatting Date() function

Date(yourdatefield, 'MMM-YY')

hope this helps

regards

Marco

Tue, 11 Oct 2016 14:33:40 GMT

Sunny, It worked with =Date(YR_MTH_KEY,'MMM-YY')

sunny_talwar — Tue, 11 Oct 2016 15:34:52 GMT

Hahahaha okay