Per Capita tables using qlik view

Fri, 22 Mar 2013 23:59:12 GMT

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.

Would appreciate any help with this.

Chau

topic Per Capita tables using qlik view in QlikView

Per Capita tables using qlik view