Sort by Severity

[Anonymous]

Hi Experts,

I have defect data . I attached source data and qvw.

in my bar chart I am showing defect count by 'Defect Cause'

now I want to sort the chart based on defect count by Severity

In my example

Configuration2 have 3 critical defects but Configuration3 also have 3 critical defects .

in this case I need to consider high severity defects, now Configuration3 has more high severity defects than Configuration2

So my first bar should be Configuration3 then Configuration2 , Configuration4 and Configuration1

Hope I am clear on my requirement. !

Thanks

BKC

[Gysbert_Wassenaar]

The qlikview document you posted contains only one Severity value.

Maybe you can get what you need by sorting by an expression like: count([Defect ID])*100+rank(Severity)

[Anonymous]

Hi ,

Plz find updated file (I forget to reload).

[Gysbert_Wassenaar]

See attached qvw.

[Anonymous]

hi Gysbert,

Thanks for your reply.

Configuration2 should be in 2nd place as this one having 3 critical defects .

Thanks

BKC

[Gysbert_Wassenaar]

Adjust the sort expression as needed.

[#7]

You just need to adjust Gysbert's expression slightly.

sum(aggr(count([Defect ID])*rank(Severity),Severity,[Defect Cause])) with desc should work fine

or

sum(aggr(count([Defect ID])*rank(Severity),Severity,[Defect Cause]))*-1 with asc

Joe

[Anonymous]

Its not working as expected ... If config2  have 3 critical defects and config3 has 4 critical defects and I add more severity 2-High in Configuration2  then confing2 is comming in first place. config3 should be in first place as it is having 4 .

Plz help

Thanks

BKC