Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

View solution in original post

Not applicable
Author

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

sunny_talwar

Hahahaha okay