Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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-
Hi, would this work for pivot tables in qlikview?
Also, how can I rename the rows to what I like? LIke instead of 0<=x<0.1