topic SET ANALYSIS in QlikView

SET ANALYSIS

Tue, 03 Dec 2013 14:40:04 GMT

I have created a table using set analysis, i just cant get my last column to work,

I want to sum up everything where CUST ends in _L4 but is not TELEPHONE_L4

SUM({$ <[CUST] = {"*_L4"}-{"TELEPHONE_L4"}>[revenue])

What syntax do i need for this?

Also does set analysis heavily increase the memory usage as my document appears to be a lot slower?

Re: SET ANALYSIS

swuehl — Tue, 03 Dec 2013 14:51:25 GMT

There is a closing curly bracket missing before [revenue]:

SUM({$ <[CUST] = {"*_L4"}-{"TELEPHONE_L4"} >} [revenue])

If that doesn't help, what exactely do you mean with 'can't get my last column to work'. Some sample input data, the context of your expression and expected outcome might help to understand.

Re: SET ANALYSIS

jerrysvensson — Tue, 03 Dec 2013 15:10:06 GMT

Try:

SUM({$ <[CUST] = {"*_L4"}, [CUST] = E({<[CUST]= {"TELEPHONE_L4"}>} [CUST]) >} [revenue])

Re: SET ANALYSIS

alexis — Tue, 03 Dec 2013 23:09:13 GMT

Try this:

Sum({$<CUST={"*_L4"},CUST-={$(=TELEPHONE_L4)}>}revenue)

regards

Alexis

Re: SET ANALYSIS

Anonymous — Fri, 13 Jun 2014 09:06:14 GMT

Try Like this

Sum({$<CUST = {"*_L4"}-{'TELEPHONE_L4'}>} [revenue])

The above expression will gives the output as

Sum of revenue excluding the TELEPHONE..

Re: SET ANALYSIS

sujeetsingh — Fri, 13 Jun 2014 09:11:58 GMT

Can try iff