Analytics and condition based calculation in straight table

[askarkhan]

Hi,

please check the below table,

definition table and score gained:

process_id	process_name	domain_name	parameter	Definition_no	Question_definition	score gained	max_weightage
ID0034	partno34	SKILLS	POLITENESS	Defenition1	OPENING	5	5
ID0034	partno34	SKILLS	POLITENESS	Defenition2	BRANDING	2.5	5
ID0034	partno34	SKILLS	POLITENESS	Defenition3	DISCONNECT	10	10
ID0034	partno34	SKILLS	POLITENESS	Defenition4	AGGRESSIVE	5	5
ID0037	partno37	SKILLS	POLITENESS	Defenition1	OPENING	5	5
ID0037	partno37	SKILLS	POLITENESS	Defenition2	BRANDING	5	5
ID0037	partno37	SKILLS	POLITENESS	Defenition3	DISCONNECT	0	10
ID0037	partno37	SKILLS	POLITENESS	Defenition4	AGGRESSIVE	5	5

Here i want to display over all score gained processid wise and parameter wise.

Resultant table:

process_id	parameter	score gained	Percentage
ID0034	POLITNESS	22.5	90%
ID0037	POLITNESS	0	0%

explanation:

For process_id: ID0034 , score gained is parameter politeness is (5+2.5+10+5) i.e., 22.5 out of 25, percentage= 90%

For process_id: ID0037, score gained is parameter politeness is (5+5+0+5) out of 25,

But the condition is if there is any zero (0) in score then for that particular process_id whole parameter score gained will zero.

So for process_id ID0037, there is 0 score in definition 3, So overall score it should show 0%.

please help me with the calculation in straight table qlikview.

[MayilVahanan]

Hi

Might be, try like below

If(Min([score gained]) =0, 0, Sum([score gained]))

If(Min([score gained]) =0, 0, Sum([score gained]) / Sum(max_weightage))