topic Re: Sort by Severity in QlikView

Sort by Severity

Anonymous — Thu, 07 May 2015 09:27:58 GMT

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

Re: Sort by Severity

Gysbert_Wassenaar — Thu, 07 May 2015 09:37:49 GMT

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)

Re: Sort by Severity

Anonymous — Thu, 07 May 2015 09:46:36 GMT

Hi ,

Plz find updated file (I forget to reload).

Re: Sort by Severity

Gysbert_Wassenaar — Thu, 07 May 2015 09:55:11 GMT

See attached qvw.

Re: Sort by Severity

Anonymous — Thu, 07 May 2015 11:04:28 GMT

hi Gysbert,

Thanks for your reply.

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

Thanks

BKC

Re: Sort by Severity

Gysbert_Wassenaar — Thu, 07 May 2015 11:09:01 GMT

Adjust the sort expression as needed.

Re: Sort by Severity

Thu, 07 May 2015 12:14:26 GMT

You just need to adjust Gysbert's expression slightly.

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

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

Joe

Re: Sort by Severity

Anonymous — Thu, 07 May 2015 13:47:01 GMT

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