topic Re: Set analysis problem in QlikView

Set analysis problem

Mon, 27 Aug 2012 15:26:42 GMT

Hi, I'm having trouble with my set analysis. Basically, I use the following set analysis and it disregards the 'level' criteria. Thanks, Jim

)

sum({<LevelName={'NonMat Deposits'},

period = {'1'},

level = {'4'}>}PerInt)

sum({$LevelName={'Non-Wholesale','Time Deposit Adjustments'},

period = {'1'},

level = {'4'}>}PerInt)

)

Re: Set analysis problem

bgerchikov — Mon, 27 Aug 2012 15:40:30 GMT

Hi,

Not quite sure whether you use correct syntax. You have "$" instead of "<" in second Sum. Also, I'd suggest try this instead:

sum({<LevelName={'NonMat Deposits','Non-Wholesale','Time Deposit Adjustments'},

period = {'1'},

level = {'4'}>}PerInt)

Re: Set analysis problem

Mon, 27 Aug 2012 15:51:27 GMT

sorry I miss typed it, I have the $ and < in both places. The reason I add the 2 is that the level for NonMat Deposits is 2 and the level for Non-Wholesale and Time Deposits is 3 and 4.

Re: Set analysis problem

Mon, 27 Aug 2012 20:31:33 GMT

got it. actually you're suggestion made me realize I had wrong cases. QV is case sensitive... duh!!! Thanks!

Re: Set analysis problem

whiteline — Mon, 27 Aug 2012 20:34:02 GMT

the level for NonMat Deposits is 2

but you use 4:

sum({<LevelName={'NonMat Deposits'},

period = {'1'},

level = {'4'}>}PerInt)

Re: Set analysis problem

Mon, 27 Aug 2012 20:37:11 GMT

yes you are correct. I've fixed that as well as the casing, so all is well. Thanks again.