topic Re: Convert numeric field data into period in QlikView

Convert numeric field data into period

baliyan_vinay — Wed, 27 Mar 2019 10:51:20 GMT

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.

Re: Convert numeric field data into period

raman_rastogi — Wed, 27 Mar 2019 11:17:52 GMT

try Class Function
Class([Days Open] ,20)

Re: Convert numeric field data into period

baliyan_vinay — Wed, 27 Mar 2019 11:32:17 GMT

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?

Re: Convert numeric field data into period

raman_rastogi — Wed, 27 Mar 2019 11:50:43 GMT

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