topic Set analysis show dimension that does not correspond to another in QlikView

Set analysis show dimension that does not correspond to another

Fri, 10 Aug 2012 14:00:35 GMT

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)

???

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

shree909 — Fri, 10 Aug 2012 14:04:18 GMT

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

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

Fri, 10 Aug 2012 14:12:10 GMT

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

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

Mon, 13 Aug 2012 11:34:14 GMT

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)

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

Mon, 13 Aug 2012 11:54:15 GMT

Hope this helps!

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

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

chematos — Mon, 13 Aug 2012 20:49:56 GMT

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

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

Tue, 14 Aug 2012 05:26:51 GMT

Hi Aizpurietis

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

Thanks,

Attitude

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

senpradip007 — Tue, 14 Aug 2012 06:09:46 GMT

Hi aiz,

You can use the following

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

Hope it will help you.

Cheers

PRADIP