Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Common Date

Hi!

I have a data file that contains Date and Product. Example:

Date                              Product

1/2/2016 00:12 AM       ProductA

3/12/2016 8:12 AM       ProductB

...

6/27/2016 5:54 PM       ProductZ

i want to get the peek hours of a product regardless of the date. I just need the time. For example, product A is sold mostly at 5:00 PM.

I used the expression Time(date(Date)) but it returns all instances of time in each date. I just want all common instances of time to appear once. Thank you!

1 Solution

Accepted Solutions
kaushiknsolanki

Hi,

Try this.

Time(Date(Date) - Floor(Date(Date)))

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
kaushiknsolanki

Hi,

Try this.

Time(Date(Date) - Floor(Date(Date)))

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

hi,

Try

=Hour(Date)

-TR,

Abdul

Not applicable
Author

Really worked for this situation. Thanks!