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

Regarding Simple Grouping - Beginner Needs Help

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.

3 Replies
swuehl
MVP
MVP

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-

Not applicable
Author

Hi, would this work for pivot tables  in qlikview?

Not applicable
Author

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