topic Re: How to display missing ranges in bin in QlikView

How to display missing ranges in bin

Mon, 01 Sep 2014 15:42:28 GMT

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

Re: How to display missing ranges in bin

MK_QSL — Mon, 01 Sep 2014 15:51:58 GMT

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

Re: How to display missing ranges in bin

MarcoWedel — Mon, 01 Sep 2014 22:45:29 GMT

Hi,

another solution:

hope this helps

regards

Marco