Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
baliyan_vinay
New Contributor II

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
Partner
Partner

Re: Convert numeric field data into period

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

Re: Convert numeric field data into period

try Class Function
Class([Days Open] ,20)
baliyan_vinay
New Contributor II

Re: Convert numeric field data into period

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?

Partner
Partner

Re: Convert numeric field data into period

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