# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for
Did you mean:
Highlighted Contributor II

## How to Convert Range(percentage calculation) in to Dimension?

Hello Experts,

How to Convert Range(percentage calculation) bucket in to Dimension?

Example:

i have a filed name skills,student ,status,need to know their completed Percentage

like

student, skills,completed skills, completed %,range(%)

s1,24,20,83%,81-100

s2,24,24,100%,81-100

s3,24,9,37%,21-40

s4,24,15,62%,61-80

s5,24,3,12%,0-20

Now i need to convert this range(% )in dimension.please find the attached screenshot which way i needed

i have done this way but getting different result

if( aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))),STUDENT)<='1'

and ( aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))),STUDENT))  > '0.8','81-100',

if(aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/(count(DISTINCT(skills))),STUDENT)<= '0.8'

and ( aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))),STUDENT)) > '0.6','61-80',

if(aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))),STUDENT)<= '.6'

and ( aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))),STUDENT)) > '0.4','41-60',

if(aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))),STUDENT)<='0.4'

and ( aggr(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))),STUDENT)) > '0.2','21-40','0-20'

))))

regards

kiran

2 Replies
Highlighted Master II

## Re: How to Convert Range(percentage calculation) in to Dimension?

What dimension you have in backend?

If you have Completed %  as field then use same if conditions in your script to create a bucket

Highlighted Contributor II

## Re: How to Convert Range(percentage calculation) in to Dimension?

Hello Shahbaz,

this what i have created for bucket

if(

((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))) <= '1'

and

((count({\$<status={'1'}>}DISTINCT(skills)))/(count(DISTINCT(skills)))) > '.8','100-81',

if(((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))) <= '.8'

and

((count({\$<status={'1'}>}DISTINCT(skills)))/(count(DISTINCT(skills)))) > '.6','80-61',

if(((count({\$<status={'1'}>}DISTINCT(skills)))/(count(DISTINCT(skills)))) <= '.6'

and

((count({\$<status={'1'}>}DISTINCT(skills)))/( count(DISTINCT(skills)))) > '.4','60-41',

if(((count({\$<status={'1'}>}DISTINCT(skills)))/(count(DISTINCT(skills)))) <= '.4'

and

((count({\$<status={'1'}>}DISTINCT(skills)))/(count(DISTINCT(skills)))) > '.2','21-40','20-0'

))))

couldn't able to load in script level,

this i need to convert it to dimension

regards

Kiran