Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DateFormat problem in machines

Hi all,

In my application having a field CaptureDateTime and displays data in "Date" format(M/D/YY) in listbox

but when i'm using it in straight table with another field as calculated dimension then instead of displaying in "Date" format it is displaying in "Number" format.

Please find the attached application.

1 Solution

Accepted Solutions
giakoum
Partner
Partner

Date is only a formatting function, so in order to see it correctly, you need to reapply Date in your dimension :

=date(CaptureDate) &' '& Pick(WildMatch(vTimeRange,'5*','10*'),[5mins],[10mins])

But still it it stored as a number in QlikView

View solution in original post

2 Replies
giakoum
Partner
Partner

Date is only a formatting function, so in order to see it correctly, you need to reapply Date in your dimension :

=date(CaptureDate) &' '& Pick(WildMatch(vTimeRange,'5*','10*'),[5mins],[10mins])

But still it it stored as a number in QlikView

View solution in original post

Not applicable
Author

hi

simply write

Date(fieldname)