Bucketing unique record entries

Anonymous — Tue, 24 Apr 2018 12:09:13 GMT

Hi All,

Data looks as below, A Ticket is tagged to multiple Types .

Ticket ID	Type
A	Very High
A	High
A	Low
B	High
B	Medium
C	High

A Ticket count has to be calculated only in one bucket. i.e., if a Ticket is tagged to 'Very High', 'High' or 'Low' , it's count should be shown only in 'Very High' . Similarly if a ticket is tagged to High and Low, its count should be reflected only in High Bucket.

Current State

Very High	High	Medium	Low
1	3	1	0

Expected State

Very High	High	Medium	Low
1	2	0	0

Please let me know if you need further details.

Thanks,

Re: Bucketing unique record entries

sunny_talwar — Tue, 24 Apr 2018 12:15:09 GMT

I like solving these kind of problem by assigning a numeric value to the text (Type)

Script

Table:

LOAD *,

Match(Type, 'Very High', 'High', 'Medium', 'Low') as TypeNum;

LOAD * INLINE [

Ticket ID, Type

A, Very High

A, High

A, Low

B, High

B, Medium

C, High

];

In your chart

Dimension

Type

Expression

=Sum(Aggr(If(TypeNum = Min(TOTAL <[Ticket ID]> TypeNum), 1), [Ticket ID], TypeNum))

topic Bucketing unique record entries in QlikView

Bucketing unique record entries

Re: Bucketing unique record entries