topic Re: Help with Set Analysis in QlikView

Help with Set Analysis

Fri, 05 Jul 2013 07:54:32 GMT

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...

alexandros17 — Fri, 05 Jul 2013 07:58:32 GMT

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

try this

Fri, 05 Jul 2013 09:36:26 GMT

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

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