Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
michele_stenico
Partner
Partner

How drawing a Matrix showing number of changes between a current and previous Class

Hi,

I start from this kind of Input Date

NDC,Data,Class
1,2020/01/01,A
1,2020/02/01,B
2,2020/01/01,A
2,2020/02/01,A
3,2020/01/01,C
3,2020/02/01,A
4,2020/01/01,B
4,2020/02/01,B
];

I would like  to count the number of Class Changing of my Customer and show the results in a matrix like this.

  Current Class
  ABC
Previous ClassA110
B010
C100

 

I could calculate the previous Class in the Load Script, using previous function, but I would like to be able to do it in the presentation, may be using additional dimension (e.g Class_Prev, Class_Cur).

Could you help me ?

Michele

 

 

 

 

 

 

 

 

Labels (3)
1 Reply
michele_stenico
Partner
Partner
Author

Sorry, the example table was badly posted, that is

             A        B           C

A          1        1           0

B          0        1           0

C          1         0          0

thanks