topic Re: Calculated Dimension in App Development

Calculated Dimension

amusia — Fri, 15 Feb 2019 19:10:51 GMT

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

Re: Calculated Dimension

jwjackso — Fri, 15 Feb 2019 20:19:05 GMT

Try

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

Re: Calculated Dimension

pradosh_thakur — Fri, 15 Feb 2019 21:23:20 GMT

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')))