Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count the values?

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.

6 Replies
sunny_talwar

Check this link out:

Buckets

Anonymous
Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

Now use

Bucket as dimension and count(Value) as expresison.

Regards,

Jagan.

JaMajka1
Partner Ambassador
Partner Ambassador

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