Row level % in Qliksense

[Biswa88]

Hi All,

I am new to Qlik sense and while working on Qlik I am stuck in one point where I want to calculate % of Downtime ?

Name	Time	Downtime	% of Downtime
A	Morning	2	25%
A	Afternoon	0.5	6%
A	Evening	1.5	19%
A	Night	4	50%
B	Afternoon	2	31%
B	Evening	1.5	23%
B	Night	3	46%
C	Morning	5	63%
C	Afternoon	2	25%
C	Evening	1	13%

[rwunderlich · Accepted solution]

I assume % is the percent of the "Name" group. If so, then the expression to calculate ratio within the Name is:

Sum(Downtime) / sum(TOTAL<Name> Downtime)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Biswa88]

Thanks Rob. It worked. 

[rwunderlich]

Great. Then please like the answer and mark it as solution. 

-Rob