How to count this?

[Anonymous]

Hi there,

Very new to Qlikview. I have got a raw data file with over 2 million rows of data (sample extract attached).

I would like to do some simple counts in a straight table as follows: What will the expression statements be like?

Please assist. Thank you in advance. 

[karthikoffi27se]

Hi Ashnil,

For number of employees please use the below formula

=Count(Distinct Employee Name)

and if the value for fines are repetitive then use

=Count(Distinct Fine ID)

else

Count(Fine ID)

Many Thanks

Karthik

[effinty2112 · Accepted solution]

Hi Ashnil,

You can create a straight table like this:

Num of Fines	count(DISTINCT [Employee Name])
1	2
2	2
3	1

the first column is a calculated dimension:

=Aggr(Count([Fine ID]),[Employee Name]) which I labelled Num of Fines

cheers

Andrew

[sasiparupudi1]

Like Below?

Dimension

Employee Name

Exp1:No of Emp

count( [Employee Name])

Exp2: No OF Fines

Count(Distinct [Fine ID])