This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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..
Try (look attached file)
Month(Timestamp#([Date field], 'MM/DD/YYYY hh:mm:ss'))
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)
Anyone have any diff idea to get the necessary output ?
The ideas provided look quiet good.
So please explain what doesn't work for you exactly?
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:
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...