Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Re: Help with Set Analysis

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

try this

Not applicable

Re: Help with Set Analysis

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

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