I am new to qlikview and trying to analyze data using qlikview pivot.
I have a set of users adopting new technology in a phased approach and I am trying to understand the behavior in terms of how many problems they report with the new technology and when once they start using it.
I am trying to relate a pivot that allows me to see number of problems reported per user who adopted the new technology on Day 1 to Day 7 after they were given access to the new technology.
A sample set of data to explain the use case is:
ClientID
Adoption Date
A
1/9/2013
B
1/11/2013
C
1/10/2013
D
1/14/2013
E
1/11/2013
F
1/7/2013
G
1/7/2013
Problem#
ClientID
Time Reported
Days since Adoption
1
A
1/10/2013
1
2
A
1/11/2013
2
3
B
1/11/2013
0
4
B
1/12/2013
1
5
A
1/12/2013
3
6
C
1/14/2013
4
7
D
1/14/2013
0
8
D
1/14/2013
0
9
A
1/13/2013
4
10
A
1/14/2013
5
11
E
1/12/2013
1
12
E
1/12/2013
1
13
E
1/13/2013
2
14
E
1/13/2013
2
15
E
1/13/2013
2
16
A
1/14/2013
5
Days Since Adoption
0
1
2
3
4
5
Problems Reported per adopted user
3 problems/7 users
4 problems/7 users
4 problems/7 users
1 problem/7 users
2 problems/7 users
2 problems/7 users
I would also like to keep the flexibility to filter my pivot by region/ group of clients/particular roll out date. Not sure if i need to keep in mind any considerations while in the denominator of the expression.
