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

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: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
Labels
MATRIX.xlsx
1,493 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
1,399 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
1,400 Views
arsenal1983
Creator
Creator
‎2016-04-08 07:16 AM
Author

In response to sunny_talwar

you truly are a legend

1,399 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

1,399 Views
0 Likes