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

Set Analysis using E() function.

Hi!

I have the following Set Analysis expression:

sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}>}January)

- sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'015'}, Business={'Oil'}>}January)

- sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'017'}>}January)

- sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2601}, SubAccount={'002','008','009','007','012','013','014'}>}January)

I need to translate it, using E() function. I have tried the following:

sum({$<Table={'ResultStates'} ,CodEERR = {'RNO'} ,MovType={'Real'}

,Account=E({1

     <Account={2602}, SubAccount={'015'},Business={'Oil'}>

     +<Account={2602}, SubAccount={'017'}>

     +<Account={2601}, SubAccount={'002','008','009','007','012','013','014'}>})

>}January)

since I want the word 'January' to appear just once. Of course, I'm a here and thus it means that my attempt does not work : (

Could someone lend me a hand?

Thanks!

1 Reply
Not applicable
Author

I just ended up using the exclusion sign:

sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}>

- <Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'015'}, Business={'Oil'}>

- <Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'017'}>

- <Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2601}, SubAccount={'002','008','009','007','012','013','014'}>}January)

Anyway, I would like to know how to do it via E() function.