Group results by KPI treshold

Tue, 08 Mar 2016 21:14:11 GMT

Hi,

I need to order a set of data based on KPI value (ordered) defining 4 different groups equally distributed (it's not a quartile because).

In attach you'll find a QVW example in which I need to develop a straight table like the results attached in the XLS file.

The main goal is to group dataset into 4 different cluster each on with the same number of customer.

So the procedure must be in theory something like that:

1) Calculate the KPI for each row

2) Order row by KPI (DESC)

3) Start from the first row and count each row with a unique and incremental number

4) Check if the unique number divided by the total number of rows is less than 0,25 (group1), less than 0.5 (group2), less than 0.75 (group3), less than 1 (group4)

It doesn't matter if tow rows has the same KPI.

Rows with the same value of KPI can be associated with two different group.

I have to calculate this directly in the frontend (I have a lot of complex KPI to calculate this in the ETL) and it must be independent by user selection (I mean the group assigned to a specific row must not change).

Do you have any idea?

Re: Group results by KPI treshold

settu_periasamy — Wed, 09 Mar 2016 02:45:14 GMT

Hi,

May be like the Attached?

Edit

Updated the Attachment.

Re: Group results by KPI treshold

Wed, 09 Mar 2016 09:17:47 GMT

Hi,

yes but if I select a specific customer his rank must not change.

So if I select customer "206650" his rank must be 18 and not 1.

The rank must be calculated overall on the YearMont field.

Re: Group results by KPI treshold

settu_periasamy — Wed, 09 Mar 2016 13:41:14 GMT

Updated the Attachment in the Previous Thread. Check and Let me know..

topic Group results by KPI treshold in QlikView

Group results by KPI treshold

Re: Group results by KPI treshold

Re: Group results by KPI treshold

Re: Group results by KPI treshold