topic Re: Repeat Value Count in QlikView

Repeat Value Count

Mahamed_Qlik — Sat, 25 Jul 2015 14:24:12 GMT

Hi,

If there is one field named as " Customer_Complaint" , which has multiple repeat values in it.

So, How I can make count of repeated "Customer_Complaint".

Example:

Header 1	Header 2
Date	Customer_Complaint
01/01/2014	Break
02/01/2014	Clutch
03/02/2014	Clutch
05/02/2014	Gear
10/02/2014	Clutch
20/02/2014	Break

In above example Customer_Complaint with value as "Break " repeated 2 times and "Clutch" repeated 3 times.

This is just an example, but in my database there is huge number of Customer_Complaints which are repeating.

I had tried "peek function" in script, but it compares only previous row value and In my scenario each values should compare with whole values in the same field "Customer_Complaint".

How I can do this.

Kindly Help.

Re: Repeat Value Count

sunny_talwar — Sat, 25 Jul 2015 14:33:12 GMT

Try this script:

Table:

LOAD * Inline [

Date, Customer_Complaint

01/01/2014, Break

02/01/2014, Clutch

03/02/2014, Clutch

05/02/2014, Gear

10/02/2014, Clutch

20/02/2014, Break

];

Join(Table)

LOAD Customer_Complaint,

Count(Customer_Complaint) as Count

Resident Table

Group By Customer_Complaint;

Output:

Re: Repeat Value Count

Anonymous — Mon, 28 Nov 2016 22:09:29 GMT

Thanks Sunny T! You solved my problem! And this is a very neat solution!

Re: Repeat Value Count

Navars — Sun, 27 Oct 2019 18:58:48 GMT

Hi Sunny is that possible to count the repeated values count in expression level.