Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

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.