Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Sum amounts per hour in chart

I wanna show the sum of AMOUNT per hour in a graph.

I've been trying to create a calculated dimension using maketime without any luck.

My TIME has the below format.

07:00:00:640000

Any ideas?


1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Sum amounts per hour in chart

Try

=Hour(Time#('07:00:00:640000','hh:mm:ss:ffffff'))

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Sum amounts per hour in chart

Try

=Hour(Time#('07:00:00:640000','hh:mm:ss:ffffff'))

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

Re: Sum amounts per hour in chart

Try this: =left('07:00:00:640000',2)


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Sum amounts per hour in chart

It works.

However, what If I would like the eqvivalent, but quarters of an hour instead?

Is there a quarter(hour(......  version as well?