Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to count only fields that match?

I'm building a dashboard of a partner network. I am working with the second layer of partners (partner's partners) and only want to show the count of the partners that match people we currently partner with. I currently have a field with all of the partner's partners (with a huge long tail) but I want to only display the count of partner's partners who match my companies partner list.  How can I get it to count/display the partner's that match with a list of my companies existing partners? Thanks!

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

Create a Mapping Table from your companies partner list into the field with all the partners and use that to create a 0 or 1 flag.

Then you can sum that field.

You can read about mapping here:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

or provide some data like Deepak mentioned above and it should be a quick solution.

Best,

Ali A

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

can you please provide the sample app and the output you are expecting

Highlighted
Partner
Partner

Hi,

Create a Mapping Table from your companies partner list into the field with all the partners and use that to create a 0 or 1 flag.

Then you can sum that field.

You can read about mapping here:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

or provide some data like Deepak mentioned above and it should be a quick solution.

Best,

Ali A

View solution in original post

Highlighted
Partner
Partner

Dear Matthew,

Please try as below

YOURCompanyData:

Load

.

Your companies partner . as partner

.

.

.

From YOURtable;


partnerspartner:

Load

partner's partner as  partner

.

.

.

From

partner's partner

Where EXISTS(partner, partner's partner)


then it matches.


Regards,

Mithilesh

Highlighted
Contributor
Contributor

Thank you all very much for your replys, I ended up resolving my issue using the mapping