Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Seems to be CALENDAR OBJECT
go to tabe Number ...>Override Document setting(check)....>Date(check)....>Format pattern(MM-DD-YYYY)
Sorry Allu, its not clear to me. Could you please elaborate?
hi, see attached sample
hope this helps
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).
Hi
PFA
Hi Marc,
PFA