Calculated Dimension

[amusia]

Hello Qlik Community!

I need to create a Calculated Dimension with 3 categories: Integrated Sets, Standalone Sets, Automated Sets. I am working with data that contains thousands of test sets. The "integrated" test sets have a naming convention of "INT.XXX.12345" and the Standalone test sets have a naming convention of "OTC.XXX.1234". The Automated test sets can be both integrated and standalone, but contain a specific value of "Test_Team_Auto" in another column called [Set Team Owner]. Can someone help me create a calculated dimension that will specify Integrated, Standalone, and Automated? Thank you in advance!

Anthony 

[jwjackso · Accepted solution]

Try

=If([Set Team Owner] = 'Test_Team_Auto','Automated',
If(WildMatch(SET,'INT*') > 0,'Integrated',
If(WildMatch(SET,'OTC*') > 0,'Standalone',NULL())))

[pradosh_thakur · Accepted solution]

if(Wildmatch(yourfield,'INT.*'),'Integrated',if(Wildmatch(yourfield,'OTC.*'),'Standalone', if((Wildmatch(yourfield,'INT.*') orWildmatch(yourfield,'OTC.*')) and [Set Team Owner] = 'Test_tam_auto','Automated','Not applicable')))