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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.