Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aschmeelk
Contributor III
Contributor III

Counting Time Stamps

I have a timestamp that represents when an item has been scanned by a barcode reader. I want to count these timestamps to determine how many scans are occurring during a given time period. I'm a little stumped, as my attempts to count using aggregation functions don't seem to work. Any help provided will be greatly appreciated!

Labels (1)
2 Replies
MarcoWedel

There should be nothing special about counting timestamps.
Can you describe the relevant parts of your data model and the expressions you are using?

aschmeelk
Contributor III
Contributor III
Author

Hello Marco! Thanks for responding. The relevant expression I'm using to create the time stamp is below:

------ begin code snippet --------------------------

IF([AUDIT_POSTNAME]='CASING_EDIT' OR
[AUDIT_POSTNAME]='INITIAL_INSPECTION' OR
[AUDIT_POSTNAME]='BUFFER' OR
[AUDIT_POSTNAME]='CIA' OR
[AUDIT_POSTNAME]='SKIVE' OR
[AUDIT_POSTNAME]='REPAIR' OR
[AUDIT_POSTNAME]='PRE_MOLD' OR
[AUDIT_POSTNAME]='FINAL_INSPECTION' OR
[AUDIT_POSTNAME]='SHIPPING' OR
[AUDIT_POSTNAME]='RECIEVING' OR
[AUDIT_POSTNAME]='ADJUSTMENT', timestamp(Min([Audit Create])))

------ end code snippet --------------------------

Where Audit Create is a date/time dimension.

I want to count the number of these 'timestamps' created over a specified time period to represent on a bar chart to see when the greatest number of them occur.