Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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.