I am new to qlikview, hence please pardon me if this is rather straightforward.
I have a requirement to count the number of customer that falls under a certain rating over the respective month. the objective is to measure how many customer got improved or worst off rating across the months.
To keep it simple, i have a dataset with 3 columns; [CUSTOMER], [MONTHYEAR], [RATING]. below is a sample:
CUSTOMER
MONTHYEAR
RATING
CUSTOMER A
Mar-21
10
CUSTOMER A
Apr-21
10
CUSTOMER A
May-21
10
CUSTOMER A
Jun-21
10
CUSTOMER A
Jul-21
10
CUSTOMER A
Aug-21
10
CUSTOMER A
Sep-21
10
CUSTOMER A
Oct-21
10
CUSTOMER A
Nov-21
10
CUSTOMER A
Dec-21
9
CUSTOMER A
Jan-22
9
CUSTOMER A
Feb-22
9
CUSTOMER A
Mar-22
8
CUSTOMER B
Mar-21
5
CUSTOMER B
Apr-21
5
CUSTOMER B
May-21
5
CUSTOMER B
Jun-21
5
CUSTOMER B
Jul-21
6
CUSTOMER B
Aug-21
6
CUSTOMER B
Sep-21
6
CUSTOMER B
Oct-21
6
CUSTOMER B
Nov-21
6
CUSTOMER B
Dec-21
6
CUSTOMER B
Jan-22
6
CUSTOMER B
Feb-22
7
CUSTOMER B
Mar-22
7
The expected output should be as such (if the user selected May-21 and Feb-22):
May-21
Feb-22
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
1
6
7
8
9
10
1
from the above table, it should tell the user that there is a customer has a rating of 5 in May-21 and rating of 7 in Feb-22, and that a customer with rating of 10 in May-21 and rating of 9 in Feb-22.
Can any experts direct me on how to accomplish this in Qlikview please?
