How to count the values?

[#1]

I am new to QlikSense. I have following values –

Values
5
35
14
4
19
45
22
24

I need your help in displaying the following table –

Value Range	Count
1 to 10	2
11 to 20	2
21 to 30	2
31 to 40	1
41 to 50	1

What's syntax to do this ? Need to display this in “Table” or “Text & Image”.

Awaiting your response.

[sunny_talwar]

Check this link out:

Buckets

[sunny_talwar]

Also check out the class function:

Class Function Example‌

QlikView | Expressions | Class Function - YouTube

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ConditionalFunctions/c...

[Anonymous]

Dimension:

If(values>= 1 and values <= 10 , '1 to 10',

If(values>= 11 and values <= 20 , '11 to 20',

  if(values>= 21 and values <= 30 , '21 to 30',

   If(values>= 31 and values <= 40 , '31 to 40',

      '41 to 50'))))

Then just you 'Count(values)'....

[jagan]

Hi,

Try this

LOAD

*,

(Floor(Values/10) * 10)  & '-' & (Ceil(Values/10) * 10) AS Bucket

INLINE [

Values

5

35

14

4

19

45

22

24];

[jagan]

Now use

Bucket as dimension and count(Value) as expresison.

Regards,

Jagan.

[JaMajka1]

You can use Class(Values,10) as a dimension and Count(Values) as a measure.