topic Re: How to remove timing? in QlikView

How to remove timing?

Wed, 21 May 2014 06:16:35 GMT

Hi~

i have a plan start time table inside my qlikview. my boss want to look at the keys that break done by month. but if u see the file there has different timing in the list box so how to remove the timg only left month so i can do the chart for keys.

Re: How to remove timing?

jagan — Wed, 21 May 2014 06:46:14 GMT

Hi,

Try like this

LOAD

Date(Date#(Trim(Left(Trim(SubField(Only([Plan_End_Time/fieldvalue]), ',', 2)), 11)), 'D MMM YYYY')) AS Date

FROM DataSource;

Regards,

Jagan.

Re: How to remove timing?

Wed, 21 May 2014 06:52:49 GMT

Thanks for helping! but it did not work out.

Re: How to remove timing?

jagan — Wed, 21 May 2014 08:23:15 GMT

Hi,

Do you want fetch only date from this column Plan_End_Time/fieldvalue? Then this works

Date(Date#(Trim(Left(Trim(SubField(Only([Plan_End_Time/fieldvalue]), ',', 2)), 11)), 'D MMM YYYY'))

I am able to retrieve date.

Regards,

Jagan.

Re: How to remove timing?

Wed, 21 May 2014 08:25:07 GMT

So where u put the syntax? in edit script?

Re: How to remove timing?

Wed, 21 May 2014 08:29:37 GMT

Use Date(Floor())

Re: Re: How to remove timing?

jagan — Wed, 21 May 2014 08:59:24 GMT

HI,

I tried it in a Text Object, the same should work in Load script also. Please find attached file for solution.

Regards,

Jagan.

Re: Re: How to remove timing?

ashfaq_haseeb — Wed, 21 May 2014 11:09:00 GMT

Hi,

Go through the attached file.

Regards

ASHFAQ

Re: How to remove timing?

Thu, 22 May 2014 01:48:50 GMT

Sorry, i cant open ur file as my qlikview is personal edition. can i know which text box? is it "expression text box"?

Re: How to remove timing?

jagan — Thu, 22 May 2014 01:50:32 GMT

Hi,

It is a separate Text Object, select any time and put this in text object

=Date(Date#(Trim(Left(Trim(SubField(Only([Plan_End_Time/fieldvalue]), ',', 2)), 11)), 'D MMM YYYY'))

Regards,

jagan.