Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

arsenal83
Contributor

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.

Tags (3)
1 Solution

Accepted Solutions

Re: migration matrix

Try this:

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


Capture.PNG

3 Replies

Re: migration matrix

Try this:

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


Capture.PNG

arsenal83
Contributor

Re: migration matrix

you truly are a legend

Re: migration matrix

I am glad I was able to help

Community Browser