Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.