Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
baliyan_vinay
Contributor III
Contributor III

Convert numeric field data into period

Hi Community,

I've a below data in a dimension and want to use it as X-Axis for a bubble chart. 

Days Open
4
9
15
16
25
44
68
75
127
195
219
285
361
390
415
479
564
613

 

Is there a possibility that I could somehow create a period based on minimum and maximum value and divide it into like 8-10 periods?

Thank you Guys. Cheers.

1 Solution

Accepted Solutions
raman_rastogi
Partner - Creator III
Partner - Creator III

Add Your dimension with class function. Scatter Plot show expressions values on axis instead of dimension values.

View solution in original post

3 Replies
raman_rastogi
Partner - Creator III
Partner - Creator III

try Class Function
Class([Days Open] ,20)
baliyan_vinay
Contributor III
Contributor III
Author

Thanks Raman. Should I add it in script or add as expression? Also I tried to utilize the scatter plot for this but it sums up axis dimension data, do you know what could be the reason?

raman_rastogi
Partner - Creator III
Partner - Creator III

Add Your dimension with class function. Scatter Plot show expressions values on axis instead of dimension values.