Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Numeric value is shown when selecting date-value

Dear all,

I have the following Qlikview file in which I created a date-object in which I can select a data. If I create a text object in which show the the selected variable as object using =date(vDateInput) it shows the selected date.

But when I select a data I the date-object I do not see date but I see a numeric value. Any thoughts on how I can make sure I see a normal date here?

6 Replies
Anonymous
Not applicable
Author

Hi

Seems to be CALENDAR OBJECT

go to  tabe Number ...>Override Document setting(check)....>Date(check)....>Format pattern(MM-DD-YYYY)

Not applicable
Author

Sorry Allu, its not clear to me. Could you please elaborate?

Frank_Hartmann
Master II
Master II

hi, see attached sample

hope this helps

Unbenannt.png

qlik_venu
Creator
Creator

adding to the above answers,

You can also format your date range using

VFromDate: DATE#(20110101,'yyyymmdd')

and in the range definition of the calendar object you can use $(VFromDate).

Anonymous
Not applicable
Author

Hi

PFA

raju_insights
Partner - Creator III
Partner - Creator III

Hi Marc,

PFA

test.JPG