Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Convert numeric field data into period

try Class Function
Class([Days Open] ,20)
Highlighted
Contributor III
Contributor III

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?

Highlighted
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.

View solution in original post