Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
Like Below?
Dimension
Employee Name
Exp1:No of Emp
count( [Employee Name])
Exp2: No OF Fines
Count(Distinct [Fine ID])