Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hello My name is Jim and I am new to Qlikview

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!

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

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;

View solution in original post

16 Replies
MayilVahanan

HI

Try like this

Load DateField,

Year(DateField) as Year,

Month(DateField) as Month,

Time(DateField) as TIme

from tablename;

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

You should be done this in script side.

Load

     Day(DateField) AS Day,

     Month(DateField) AS Month,

     Year(DateField) AS Year

From Datasource.

Not applicable
Author

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??

MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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??

Not applicable
Author

Hi,

     I tried to reload your code and it does not work on me. Sorry for the inconvience.

CELAMBARASAN
Partner - Champion
Partner - Champion

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;

MayilVahanan

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?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thank you SO MUCH!