Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
arsenal1983
Creator
Creator
‎2016-04-08 06:55 AM

migration matrix

Hello,

Today I have very simple case, I have table with only 3 columns (attach xlsx).

   

PARTNERSCORING_CURRSCORING_FWRD
PARTNER_8223
PARTNER_8222
PARTNER_8222
PARTNER_8232
PARTNER_8233
PARTNER_8233
PARTNER_8233
PARTNER_8233

I need to create a pivot tables with % of partners quatities:

Przechwytywanie.PNG

Any suggestions.

Preview file
28 KB
694 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2016-04-08 07:08 AM

Try this:

=Count(PARTNER)/Count(TOTAL <SCORING_CURR>PARTNER)


Capture.PNG

View solution in original post

Community_212597.qvw
600 Views
3 Replies
sunny_talwar
MVP
MVP
‎2016-04-08 07:08 AM

Try this:

=Count(PARTNER)/Count(TOTAL <SCORING_CURR>PARTNER)


Capture.PNG

Community_212597.qvw
601 Views
arsenal1983
Creator
Creator
‎2016-04-08 07:16 AM
Author

In response to sunny_talwar

you truly are a legend

600 Views
0 Likes
sunny_talwar
MVP
MVP
‎2016-04-08 07:41 AM

In response to arsenal1983

I am glad I was able to help

600 Views
0 Likes