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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Polido
Contributor II
Contributor II

How to get data only every 10 seconds instead of every second?

Hello everyone!

I've tried to search if this was already solved on the forum but I only found topics about the refresh / load tasks.

I'm using a QVD that has data for every second, but I only want to populate a table / world map with data from every 10 seconds interval.

Is this possible? And how it should be done in the data load editor?

Thanks in advance!

1 Solution

Accepted Solutions
Digvijay_Singh

Something like this may be - 

source:
Load * inline [
Datetime
2020-11-05 08:37:50
2020-11-05 08:37:51
2020-11-05 08:37:52
2020-11-05 08:37:53
2020-11-05 08:37:54
2020-11-05 08:37:55
2020-11-05 08:37:56
2020-11-05 08:37:57
2020-11-05 08:37:58
2020-11-05 08:37:59
2020-11-05 08:38:00
2020-11-05 08:38:01
2020-11-05 08:38:02
2020-11-05 08:38:03
2020-11-05 08:38:04
2020-11-05 08:38:05
2020-11-05 08:38:06
2020-11-05 08:38:07
2020-11-05 08:38:08
2020-11-05 08:38:09
2020-11-05 08:38:10
];

NoConcatenate
Final:
Load Datetime
resident source
Where Mod(Second(Datetime),10)=0
;

Drop table source;

View solution in original post

2 Replies
Digvijay_Singh

Something like this may be - 

source:
Load * inline [
Datetime
2020-11-05 08:37:50
2020-11-05 08:37:51
2020-11-05 08:37:52
2020-11-05 08:37:53
2020-11-05 08:37:54
2020-11-05 08:37:55
2020-11-05 08:37:56
2020-11-05 08:37:57
2020-11-05 08:37:58
2020-11-05 08:37:59
2020-11-05 08:38:00
2020-11-05 08:38:01
2020-11-05 08:38:02
2020-11-05 08:38:03
2020-11-05 08:38:04
2020-11-05 08:38:05
2020-11-05 08:38:06
2020-11-05 08:38:07
2020-11-05 08:38:08
2020-11-05 08:38:09
2020-11-05 08:38:10
];

NoConcatenate
Final:
Load Datetime
resident source
Where Mod(Second(Datetime),10)=0
;

Drop table source;

Polido
Contributor II
Contributor II
Author

Thank you very much! I believe this will work 🙂

I still need to do more testing but the data looks good, thank you!

Cheers