topic Re: Regarding Simple Grouping - Beginner Needs Help in QlikView

Regarding Simple Grouping - Beginner Needs Help

Mon, 16 Jun 2014 21:16:06 GMT

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.

Re: Regarding Simple Grouping - Beginner Needs Help

swuehl — Mon, 16 Jun 2014 21:37:50 GMT

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.

Re: Regarding Simple Grouping - Beginner Needs Help

Tue, 17 Jun 2014 13:11:17 GMT

Hi, would this work for pivot tables in qlikview?

Re: Regarding Simple Grouping - Beginner Needs Help

Tue, 17 Jun 2014 13:46:22 GMT

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