topic Re: SET Analysis in QlikView

SET Analysis

Thu, 29 Jan 2015 10:36:58 GMT

Hi,

cannot get the below to work. Both are showing the very same result. Any ideas?

Sum({$<Amount = {"<0"}>}{$<Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"}>}{$<Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Best regards,

Olle

Anonymous — Thu, 29 Jan 2015 10:38:24 GMT

Hi,

Please can you elaborate on your expected output.

Anonymous — Thu, 29 Jan 2015 10:39:55 GMT

Try:

Sum({$<Amount = {"<0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

morganaaron — Thu, 29 Jan 2015 10:40:34 GMT

Hi Olle,

You don't need to create a new set, just to continue modifying the same set.

Try:

Sum({$<Amount = {"<0"}, Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"}, Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Thu, 29 Jan 2015 10:41:54 GMT

I need to sum up all positive values, for all counterparts, except XXX, YYY and QQQ

Same goes for negative values

//O

Anonymous — Thu, 29 Jan 2015 10:44:50 GMT

Try this and Update its working:

Sum({$<Amount = {"<0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)