How to display missing ranges in bin

[#1]

Hello,

Any idea's how I can force QV to also show ranges in a bin for which there are no data to display?

LOAD * INLINE [

    ID, RefDuty

    1, 11

    2, 19

    3, 31

    4, 32

    5, 41

];

Straight table:

Used Dimensions > Add calculated Dimension --> class(RefDuty, 10)

Expressions > Definition --> NumericCount (RefDuty)

Output:

class(RefDuty, 10)     NumericCount (RefDuty)

10 <= x < 20               2

30 <= x < 40               2

40 <= x < 50               1

Expected behavior:

10 <= x < 20     2

20 <= x < 30     0

30 <= x < 40     2

40 <= x < 50     1

Thanks

Peter

[MK_QSL]

Load

  *,

  IF(RefDuty >= 10 and RefDuty < 20, '10 <= x < 20',

  IF(RefDuty >= 20 and RefDuty < 30, '20 <= x < 30',

  IF(RefDuty >= 30 and RefDuty < 40, '30 <= x < 40',

  IF(RefDuty >= 40 and RefDuty < 50, '40 <= x < 50')))) as Class

Inline

[

  ID, RefDuty

    1, 11

    2, 19

    3, 31

    4, 32

    5, 41

];

Load * Inline

[

  Range, Class

  10 <= x < 20,10 <= x < 20

  20 <= x < 30,20 <= x < 30

  30 <= x < 40,30 <= x < 40

  40 <= x < 50,40 <= x < 50

];

Now create a straight table...

Dimension

Class

Expression

NumericCount (RefDuty)

Go to Presentation tab and untick Suppress Zero Values

[MarcoWedel · Accepted solution]

Hi,

another solution:

hope this helps

regards

Marco