Class Expression as Dimension

Thu, 19 May 2011 15:08:52 GMT

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

Re: Class Expression as Dimension

Fri, 09 Mar 2012 13:32:11 GMT

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)

topic Re: Class Expression as Dimension in QlikView

Class Expression as Dimension

Re: Class Expression as Dimension