Regarding Simple Grouping - Beginner Needs Help

[#1]

Hi, I am a beginner to Qlikview. I would like to know how to group the dimension in intervals. For instance, I have finance rates ranging from 0 to 1. Rates could be .1231, .2912, .9213 etc.  I would like to create row intervals by .10. So the rows would be 0-.099, .10-.199.2-.299 etc. I would also like to rename these group rows to 0,1,2,3 etc. I would appreciate the help. THank you.

[swuehl]

Create a straight table chart with a calculated dimension

=class(FIELD, 0.1)

Then create your expression you want to group by, e.g. for a distinct count histogram

=count(DISTINCT FIELD)

Replace FIELD with the field name of your e.g. finance rates.

For the re-labeling, you can create another expression

=rowno()-1

Then drag and drop this expression to the front and hide the calculated dimension on presentation tab.

See also attached-

[#3]

Hi, would this work for pivot tables  in qlikview?

[#4]

Also, how can I rename the rows to what I like? LIke instead of 0<=x<0.1