Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

how to display the number of times a data combination appears?

Hi, how to display a particular data combination, across multiple fields, and the number of times each combination appears in the dataset? example below. Thanks.

date

Site

Person

Count

Apr-14

AQ

Rachel

3

Apr-14

HU

ACH

7

May-14

FT

gklim

12

7 Replies
Highlighted
Champion
Champion

use

rowno() as row in your table

and use row into your table above and use straight table

and hide row field using Presentation-> select row expression and check hide

hope this helps

Highlighted
Not applicable

Hi, does rowno() count the number of rows with the same records?

Highlighted
Specialist II
Specialist II

Atually I didn't understood your point,

But taking Date, Site and Person as dimension and

count(date&site&person) will also give the count of combination of records.

If it do not helps , please elaborate more abt your req

Regards

Nitin

Highlighted
Not applicable

Basically I want to count the number of duplicate rows for each distinct combination. I want to use recno function but I don't know which part of the script to write it. Thanks.

Highlighted
Not applicable

Hi Rachel,

Just the count(date&site&person) will give the number of rows for the combination. you wouldn't need to use Recno.

Thanks,

Prabhu

Highlighted

If you have any sample data then share it, this will help a lot.

Highlighted
Not applicable

HI Rachael,

You can directly use count for counting the combination value either count(Site) or count(Person) will give you same result till they are in range of date.