Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am stuck at one place as i am beginner to Qlikview. Please help in the get the data as below.
Note : I am doing this in Front end.
I have data in below format -
Region | Emp Name | Worked Date | Activity Code |
---|---|---|---|
SA-II | A | 1/12/2017 | ACT1 |
SA-I | C | 5/12/2017 | ACT2 |
SA-II | A | 2/12/2017 | ACT3 |
SA-II | A | 3/12/2017 | ACT4 |
SA-II | B | 1/12/2017 | ACT5 |
SA-I | C | 6/12/2017 | ACT6 |
SA-I | C | 6/12/2017 | ACT7 |
SA-I | C | 6/12/2017 | ACT8 |
and I want result set in below format-
SBU | Days Worked | Total Employee |
---|---|---|
SA-I | 2 | 1 |
SA-II | 3 | 2 |
Please help me in the same. Thanks.
Looks like Count(Distinct [Worked Date]) and count(Distinct [Emp Name]), but I may not understand what you're trying to do.
Use aggr() function in expressions
Hi,
Try to do below steps,
Create below dimension:
Region
Measure:
Days Worked
count(DISTINCT [Worked Date])
Total Employee
count(DISTINCT [Emp Name])
Thanks a lot Devarasu. You are great
Hi,
Can you close this thread by marking as correct. Tks