Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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)

Community Browser