Set analysis show dimension that does not correspond to another

[#1]

Hello,

I have rather basic skills in set anlysis, so any new expressions are a challenge to me.

Can you please help me write an expression that would do this (I have two options):

1) =sum({<Q={'QN'} , S1 =blank >} Prem) 

2) =sum({<Q={'QN'} , Atj_Owner isNotEqualto {'Corporate'} and Atj_Owner isNotEqualto {'FT'} and Atj_Owner isNotEqualto {'KC'}>} Prem) 

???

[shree909]

Hi,

1) =sum({<Q={'QN'} , S1 = >} Prem)

2) =sum({<Q={'QN'} , Atj_Owner <>{'Corporate'} , Atj_Owner <>{'FT'} , Atj_Owner <>{'KC'}>} Prem)

blank means you dont wont to select nothing in that case just use s1=>,that wont get selected

[#3]

In the S1 case I would like to select those entries in the table that have no values in S1 column (some of them do and some don't due to concatenation).

[#4]

It seems that the first option is not working. Can anyone please help me in writing this expression correctly?

2) =sum({<Q={'QN'} , Atj_Owner <>{'Corporate'} , Atj_Owner <>{'FT'} , Atj_Owner <>{'KC'}>} Prem)

[#5 · Accepted solution]

Hope this helps!

=sum({<Q={'QN'} , Atj_Owner={"*"} - {'Corporate','FT','KC'}>} Prem)

[chematos]

1) =sum({<Q={'QN'} , S1 ={"=null()"} >} Prem) or maybe

=sum({<Q={'QN'} , S1 ={' '} >} Prem) // 2 simple quotes without space

2) =sum({<Q={'QN'} , Atj_Owner -={'Corporate' , 'FT','KC'}>} Prem) // -= is OK although the expression sais that is wrong

[#7]

Hi Aizpurietis

We have given the answer. Please mark as correct answer to close the thread if it is working.

Thanks,

Attitude

[senpradip007]

Hi aiz,

You can use the following

=sum({<Q={'QN'}, Atj_Owner <> {'Corporate','FT','KC'} >} Prem)

Hope it will help you.

Cheers

PRADIP