topic Re: Change time stamp into month in QlikView

Change time stamp into month

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts - I have a time stamp like below.. So now when i click on the Jan month i need the last week of the Jan(1/28) to be selected.. likewise for other months as well.. Plz advice..

1/7/2017 0:00:00

1/14/2017 0:00:00

1/21/2017 0:00:00

1/28/2017 0:00:00

2/4/2017 0:00:00

2/11/2017 0:00:00

2/18/2017 0:00:00

2/25/2017 0:00:00

3/4/2017 0:00:00

3/11/2017 0:00:00

3/17/2017 0:00:00

3/25/2017 0:00:00

4/1/2017 0:00:00

4/8/2017 0:00:00

4/15/2017 0:00:00

4/22/2017 0:00:00

4/30/2017 0:00:00

Re: Change time stamp into month

ahaahaaha — Wed, 05 Jul 2017 06:38:02 GMT

Hi,

Try (look attached file)

Month(Timestamp#([Date field], 'MM/DD/YYYY hh:mm:ss'))

Regards,

Andrey

Re: Change time stamp into month

jmvilaplanap — Wed, 05 Jul 2017 14:38:28 GMT

Is a little bit messy, but I think it can works:

WeekStart(MonthStart([Date Field]) -1)

This will return the start of the last week of the month (for each month)

Re: Change time stamp into month

bharani8 — Fri, 07 Jul 2017 11:38:08 GMT

Anyone have any diff idea to get the necessary output ?

Re: Change time stamp into month

Anonymous — Fri, 07 Jul 2017 11:42:35 GMT

The ideas provided look quiet good.

So please explain what doesn't work for you exactly?

Re: Change time stamp into month

Anonymous — Fri, 07 Jul 2017 11:53:01 GMT

I think you should rather create three listboxes for users to select their own dates. It gives the user a chance to interact with your model. and these boxes should each consist of one of the following:

Month

Year

Day

In your script you should add these three fields.

month(yourtimestampfield) as Month,

day(yourtimestampfield) as Day,

year(yourtimestampfiled) as Year

Hope this makes sense.

It is just a simpler way...