Similar to Class function but returning the number (Count) of elements in the range

Mon, 12 Dec 2011 09:10:19 GMT

Hi Guys,

Let's say I have the field SingleAverage with the values as shown below.

SingleAverage

74.5

I also have a variable vStep.

I need to create a chart DIMENSION that shows the number of values between steps (including upper limit).

In example, if vStep is 2, the DIMENSION should has

2 (70,71),

2 (72, 73)

3 (74, 74.5, 75)

Pretty similar to Class(SingleAverage, vStep, 'x'), but returning the count of values instead of a string describing the ranges.

Thanks in advance,

Aldo.

Clever_Anjos — Mon, 12 Dec 2011 13:26:59 GMT

1st step -

Create a dimension in your script with

load

subfield(Class(Expression1,10),' ', 1) as yournewdim

, [another fields]

Resident your_Data .

2st step -

Use this yournewdim inside your app and use count(yournewdim) as your expression.

topic Similar to Class function but returning the number (Count) of elements in the range in QlikView