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!
You need to use preceding load above your sql query.
Will look something like
CompletedOrders:
Load
*,
Day(DeliveryDate) AS Day,
Month(DeliveryDate) AS Month,
Year(DeliveryDate) AS Year;
SQL SELECT DeliveryDate,
CubedWeight,
DeliveryProvince,
OrderNo,
PickupPostalCode,
Pieces,
Weight
FROM CourierComplete.dbo.CompletedOrders;
HI
Try like this
Load DateField,
Year(DateField) as Year,
Month(DateField) as Month,
Time(DateField) as TIme
from tablename;
Hope it helps
You should be done this in script side.
Load
Day(DateField) AS Day,
Month(DateField) AS Month,
Year(DateField) AS Year
From Datasource.
CompletedOrders:
SQL SELECT DeliveryDate
CubedWeight,
DeliveryProvince,
OrderNo,
PickupPostalCode,
Pieces,
Weight
FROM CourierComplete.dbo.CompletedOrders;
this is my code right here, so where do i enter the code??
HI
Load * ,Day(DeliveryDate) as Day,
Year(DeliveryDate) as Year,
Month(DeliveryDate) as Month,
Time(DeliveryDate) as TIme;
SQL
SELECT
DeliveryDate
CubedWeight,
DeliveryProvince,
OrderNo,
PickupPostalCode,
Pieces,
Weight
FROM CourierComplete.dbo.CompletedOrders;
Hope it helps
CompletedOrders:
SQL SELECT DeliveryDate
CubedWeight,
DeliveryProvince,
OrderNo,
PickupPostalCode,
Pieces,
Weight
FROM CourierComplete.dbo.CompletedOrders;
this is my code right here, so where do i enter the code??
Hi,
I tried to reload your code and it does not work on me. Sorry for the inconvience.
You need to use preceding load above your sql query.
Will look something like
CompletedOrders:
Load
*,
Day(DeliveryDate) AS Day,
Month(DeliveryDate) AS Month,
Year(DeliveryDate) AS Year;
SQL SELECT DeliveryDate,
CubedWeight,
DeliveryProvince,
OrderNo,
PickupPostalCode,
Pieces,
Weight
FROM CourierComplete.dbo.CompletedOrders;
Hi
Its not working? Any error?
Load *, Day(DeliveryDate) as Day,
Year(DeliveryDate) as Year,
Month(DeliveryDate) as Month,
Time(DeliveryDate) as TIme;
SQL
SELECT
DeliveryDate,
CubedWeight,
DeliveryProvince,
OrderNo,
PickupPostalCode,
Pieces,
Weight
FROM CourierComplete.dbo.CompletedOrders;
Can you please explain about the error, if you get means?
Thank you SO MUCH!