Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display every 14th date

Hi guys,

I have a date field which contain number of dates. starting from the min date to max date count every 14th date from min date .

I need these in a separate column.

For eg: These  are the dates with date column.

Capture.PNG

I need only Dates which are selected in the image2.PNG

Labels (1)
11 Replies
Anonymous
Not applicable
Author

Thanks Robin Hausdörfer

it working or me

hi swuehl,

Yes your are saying correct

...=Min([Snapshot Date]) at the end?--this thing i am not oberving properly now i correct that

thanks swuehl for your active reply

yes your QVW is maching my exact requirement first of all i need backed column like u created inQVW script


Anonymous
Not applicable
Author

I'd just like to point out that the expression I suggested only works, if the HH:MM:SS value is exactly the same.

If not you should apply the floor() function to all timestamps.