Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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)

15 Replies
Anonymous
Not applicable
Author

I did

isingh30
Specialist
Specialist

Try this -

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

X = AutoCad

Y = Autocad..?

Please make them same.

Thank you!

isingh30
Specialist
Specialist

Screen.PNG

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
Specialist
Specialist

PFA, Solution.

Use the same script in Qliksense

Anonymous
Not applicable
Author

interesting how can I use this file?

Anonymous
Not applicable
Author

so here is like loading 2 different tables?