Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Set analysis show dimension that does not correspond to another

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

???

1 Solution

Accepted Solutions
Not applicable

Re: Set analysis show dimension that does not correspond to another

Hope this helps!

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

7 Replies
Partner
Partner

Re: Set analysis show dimension that does not correspond to another

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



Not applicable

Re: Set analysis show dimension that does not correspond to another

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

Not applicable

Re: Set analysis show dimension that does not correspond to another

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)

Not applicable

Re: Set analysis show dimension that does not correspond to another

Hope this helps!

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

Highlighted
chematos
Valued Contributor II

Re: Set analysis show dimension that does not correspond to another

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

Not applicable

Re: Set analysis show dimension that does not correspond to another

Hi Aizpurietis

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

Thanks,

Attitude

senpradip007
Valued Contributor III

Re: Set analysis show dimension that does not correspond to another

Hi aiz,

You can use the following

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

Hope it will help you.

Cheers

PRADIP