topic Re: How to count this? in QlikView

How to count this?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 10 Aug 2017 08:21:47 GMT

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 — Thu, 10 Aug 2017 08:46:33 GMT

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 — Thu, 10 Aug 2017 08:54:50 GMT

Like Below?

Dimension

Employee Name

Exp1:No of Emp

count( [Employee Name])

Exp2: No OF Fines

Count(Distinct [Fine ID])