topic Aggregate data in field for chart in QlikView

Aggregate data in field for chart

Thu, 03 Mar 2011 17:45:22 GMT

I have some data that is "years a membner" between 0 - 10. I want to put this field in our x axes on the chart. However, some of the data is 0.3 and 0.4. etc. I want all 0 to be listed as 0 yers and everything between 1-2 listed as 1. So all these different time frames are loaded as 1-10 years.

Any thoughts?

Thanks,

Aggregate data in field for chart

Thu, 03 Mar 2011 17:53:08 GMT

Hi there, is easy either you use a calculated dimension as follows:

=floor([Years as member])

Or you can add the function within the load script, which is actually better in terms of performance:

Load A, B, C, floor([Years as member]) as [Years as member Display]

from Z;

Regards