Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregate data in field for chart

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,

1 Reply
Not applicable
Author

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