Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
My name is Jim.
Right now i have to use Qlikview at my work to build KPIs and i got lots of questions.
for my date column, it filled with date, month, year and time. how do i separate all of them into different columns in qlikview??
Turn:
1/31/2004 12:00:00 AM
Into 4 different columns
Please help and thank you!
Hi, sorry i think i missed an comma some where in my code. Thank you very much!
Hi Celambarasan,
What if i want to keep the date month and year together but separate the time??? how do i put that in my code??
FinalizedOrders:
SQL SELECT DeliveryDate
CubedWeight,
DeliveryProvince,
OrderNo,
PickupPostalCode,
Pieces,
Weight
FROM CourierComplete.dbo.FinalizedOrders;
Use Date(DeliveryDate,'MM/DD/YYYY') AS DateField
Time(DeliveryDate,'hh:mm:ss') AS TimeField
Thank you Celambarasan
Use Date(DeliveryDate,'MM/DD/YYYY') AS DateField
Time(DeliveryDate,'hh:mm:ss') AS TimeField
There is a subtle error here. Date and Time are formatting functions. They will only change the display format and not group data together as you would expect. The correct way to get Date and Time from a Timestamp is with floor() and Frac(). :
Use Date(floor(DeliveryDate),'MM/DD/YYYY') AS DateField
Time(Frac(DeliveryDate),'hh:mm:ss') AS TimeField
See http://community.qlik.com/docs/DOC-3102 for more on Dates and Times.
-Rob
Thank you so much for your FYI, i was actually looking into that problem earlier with my co-worker
and our solution was to separate them into day, month, year and then group them together using the drill down group.