Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Issue

Hi,

my date looks like below

Customer Old Grade New Grade

ABC               1                    2

DEF               1                    2

XYZ                1                    3

MNO              1                    4                        

Pqr                 2                   1

so on....

now my issue is I need a pivot table with columns old grade, new grade and count of customers  where grading has been switched from old grade to new grade..

my result should look like

                             New Grade    

                              1              2             3         ............

old grade       1         2 -------->( here count 2 is there are two customers (ABC,DEF) whose grading has been moved from 1 to 2).

                   

                                      

Plesase note : I'm ok if the results can be achieved using anyother chart.

Any help is highly appreciated.

10 Replies
Not applicable
Author

Thank You Fernando.