Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

makis23190
New Contributor II

How to display only Organizations that use both types of a Software not just one or the other.

Screenshot_1.png

Name_OrgSoftware
XAutoCad
XAutodesk
YAutocad
zExcel
YExcel

Hello I would like to create a master dimension that will display Organization names that use 2 types of Software not just one or the other. For example I want only organizations that use Autocad AND Excel. What would be the function for this? Something like

Aggr(If(Software=Excel AND Softarwe= Autocad, Name_Org), Name_Org)

Tags (1)
1 Solution

Accepted Solutions
isingh30
Contributor III

Re: How to display only Organizations that use both types of a Software not just one or the other.

Try this -

if (Software = 'Excel','Autocad',Name_Org)

X = AutoCad

Y = Autocad..?

Please make them same.

Thank you!

15 Replies
isingh30
Contributor III

Re: How to display only Organizations that use both types of a Software not just one or the other.

Try this -

only({< Software = {'Excel'},{'Autocad'}>}Name_Org)

Thanks.

makis23190
New Contributor II

Re: How to display only Organizations that use both types of a Software not just one or the other.

I get erron in expression:error in set modifier expression

sureshqv
Esteemed Contributor III

Re: How to display only Organizations that use both types of a Software not just one or the other.

may be this?

only({< Software = {'Excel','Autocad'}>}Name_Org)

makis23190
New Contributor II

Re: How to display only Organizations that use both types of a Software not just one or the other.

the expression is correct but i get invalid dimension

sureshqv
Esteemed Contributor III

Re: How to display only Organizations that use both types of a Software not just one or the other.

use the correct dimension which you needed

makis23190
New Contributor II

Re: How to display only Organizations that use both types of a Software not just one or the other.

I do but I get no result

passionate
Valued Contributor

Re: How to display only Organizations that use both types of a Software not just one or the other.

Please provide some sample data.

isingh30
Contributor III

Re: How to display only Organizations that use both types of a Software not just one or the other.

Please share your data in excel sheet.

Thanks

makis23190
New Contributor II

Re: How to display only Organizations that use both types of a Software not just one or the other.

I editted

Community Browser