Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Class Expression as Dimension

Hi Guys,

I have quite a bit sample Im working with, 500K rows by 40 columns. Each person on the list is performance measured by 30 minute interval. So one person would appear throughout the day by each 30 minute increment. I want to use the class QV function to build a histogram.

The problem is, I dont want it to count by 30 minute interval but rather by day.

So instead of

DIMENSION: Class(CallsHandled,5)

EXPRESSION: Count(DISTINCT People)

I want

DIMENSION: Class(Date(CallsHandled),5)

EXPRESSION: Count(DISTINCT People)

I know by dimension above makes no sense, but i guess you guys understand what I am doing with it. Please let me know if this is at all possible

Cheers,

Byron

1 Reply
Not applicable
Author

For anyone coming across this post in their search for an answer to a similar challenge, I thought I'd signpost the following thread that may be of help:

http://community.qlik.com/message/30237#30237

... (Bryon, I can only assume that you found a solution to the question you posted above and, if so, would encourage you to share it here for the benefit of anyone searching the forum - Cheers)