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: 
Not applicable

Help with Set Analysis

Hi,

Need to get the ASSIGNMENT Values populated in a straight Table against a Dimension.The following conditions need to be applied:

1. Customer= 'NA' or 'Exception'

         AND

2. ASSIGNMENT=(starting from) 'C-' or 'c-'

        AND

3. num(Customer)= mid(ASSIGNMENT,3)

My Result : Which satisfies 1 & 2 conditions
Only({($<VERTICAL={'NA','Exception'},ASSIGNMENT={'c-*','C-*'}>)}ASSIGNMENT)

Need Help in Adding the 3rd Condition to the above SA...

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Only({($<VERTICAL={'NA','Exception'},ASSIGNMENT={'c-*','C-*'}, Customer={'$(=mid(ASSIGNMENT,3))'}>)}ASSIGNMENT)

try this

Not applicable
Author

Only({($<VERTICAL={'NA','Exception'},ASSIGNMENT={'c-*','C-*'},

Customer={'$(=mid(ASSIGNMENT,3))'}>)}ASSIGNMENT)