Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bharani8
Creator III
Creator III

Change time stamp into month

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
5 Replies
ahaahaaha
Partner
Partner

Hi,

Try (look attached file)

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


Regards,

Andrey

jmvilaplanap
Specialist
Specialist

Hi

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)

bharani8
Creator III
Creator III
Author

Anyone have any diff idea to get the necessary output ?

Anonymous
Not applicable

The ideas provided look quiet good.

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

willbleksem
Contributor III
Contributor III

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