This content has been marked as final. Show 2 replies
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.
|Technology||Total Devices||Total Scannable Devices||% Coverage|
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))