Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

datanibbler
Esteemed Contributor

"Class" function with times - what step-width to choose?

Hi,

I have implemented the time as a Dimension in my Chart.

Now I realize the actual time of an Event does not return any added value because there is only one, sometimes two Event(s) at the same time - rather I'd like to Aggregate it into buckets of one hour each.

=> I want to try to use the "Class" function to do this - only, what step-width do I  have to choose to get buckets of one hour? That would be the decimal part of a numeric datestamp, no?

Thanks a lot!

Best regards,

DataNibbler

P.S.: I just realize I can take the hour from somewhere else, so I'll do that instead, that is easier. Still, I wonder, is it possible to use CLASS to that end?

1 Solution

Accepted Solutions
Not applicable

Re: "Class" function with times - what step-width to choose?

In place of dd-mmm-yyyy you can put your date format followed by space followed by HH(hours)

2 Replies
Not applicable

Re: "Class" function with times - what step-width to choose?

Hi,

In dimension try this calculated dimension instead of dimension time.

=Timestamp(time,'dd-mmm-yyyy HH')

If you want to use class function use the following calculated dimension instead of dimension time.

=Timestamp(Class(time,1/24),'DD-MM-YYYY HH')

Not applicable

Re: "Class" function with times - what step-width to choose?

In place of dd-mmm-yyyy you can put your date format followed by space followed by HH(hours)

Community Browser