Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with Date Field

Hi stalwar1‌ ,sunny

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

Thanks for the help Sunny.

1 Solution

Accepted Solutions
MarcoWedel

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')

QlikCommunity_Thread_235845_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

8 Replies
sunny_talwar

Conditional dimension or you meant calculated dimension? Try this

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


Capture.PNG

Not applicable
Author

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

sunny_talwar

Can you post a screenshot of just YR_MTH_KEY?

Not applicable
Author

YR_MTH_KEY.jpg

sunny_talwar

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

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')

QlikCommunity_Thread_235845_Pic1.JPG

hope this helps

regards

Marco

Not applicable
Author

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

sunny_talwar

Hahahaha okay