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

[Anonymous]

Name_Org	Software
X	AutoCad
X	Autodesk
Y	Autocad
z	Excel
Y	Excel

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)

[Anonymous]

I did

[isingh30 · Accepted solution]

Try this -

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

X = AutoCad

Y = Autocad..?

Please make them same.

Thank you!

[isingh30]

Solution at script level

Temp:

LOAD Name_Org, Software

FROM (ooxml, embedded labels, table is Sheet1) Where Software = 'Excel';

Temp2:

LOAD Name_Org, Software

FROM (ooxml, embedded labels, table is Sheet1) Where Software = 'Autocad';

[passionate]

PFA, Solution.

Use the same script in Qliksense

[Anonymous]

interesting how can I use this file?

[Anonymous]

so here is like loading 2 different tables?