How to remove timing?

[#1]

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.

[jagan]

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.

[#3]

Thanks for helping! but it did not work out.

[jagan]

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.

[#5]

So where u put the syntax? in edit script?

[#6]

Use Date(Floor())

[jagan]

HI,

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

Regards,

Jagan.

[ashfaq_haseeb]

Hi,

Go through the attached file.

Regards

ASHFAQ

[#9]

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

[jagan]

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.