Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator II
Creator II

Need help in converting percentage into value

Hi,

I need some help in the percentage value. Basically I have created a table in Qlikview which has an expression which calculate percentage and I want an expression which gives the value of that percentage. For example if the percentage is 69% and I want an expression which gives value of 69% in another column.

Below is the example table which I've created and the expressions which I'm using to get the percentage value.

TechnologyTotal DevicesTotal Scannable Devices% Coverage
Desktop368,964253,75769%

As you can see from the above example for the technology desktop the percentage is 69% and I want the expression to convert 69% to the number or value in another column as Coverage Value. Below is the expression which I'm using to get the % Coverage.

% Coverage Expression : count(Total Scannable Devices)/count(Total Devices)

Total Devices Expression: count(distinct columnname)

Total Scannable Devices Expression: count(distinct if(Columnname='Scanned',Columnname))

Regards,

Bharath Vikas

2 Replies
vishsaggi
Champion III
Champion III

What you mean by number or value? What value you are looking to get there. 69% of Total devices scanned is 253,757, is this the value you are looking for?

el_aprendiz111
Specialist
Specialist

Hi,

1 option

POR.png