Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
hi
simply write
Date(fieldname)