topic AW:Using Set Analysis in QlikView

Using Set Analysis

Wed, 27 Apr 2011 12:10:12 GMT

Hi,

in a document I have a pivot chart with Year and Month as dimensions and an Amount as an expression. In a list box I have joined year with month and with recordtype. I don't want to use recordtype with a dimension but I could have temporary and definitive records. When I select the recordtype I want to calculate the sum of the amount with the selected recordtype and for year and month measure.

I have tried to use this expression, unsuccessfully: sum({$<RecordType>} Amount), but I have the sum respect of year and month dimension but not for the selected RecordType.

Any suggests to me, please?

Thanks

AW:Using Set Analysis

brenner_martina — Wed, 27 Apr 2011 12:37:30 GMT

Hi,

the right expression would be:

sum({$<RecordType={RecordType}>} Amount),

AW:Using Set Analysis

Wed, 27 Apr 2011 12:52:53 GMT

Thanks, but it doesn't function. I have tried to put a specific value for RecordType:

sum({$<RecordType={'Def'}>})

In this way, that I don't want, I have the right sum.

AW:Using Set Analysis

Wed, 27 Apr 2011 13:11:01 GMT

Hi,

the second solution is right, you just have to define a variable which will store "record type" and use it as a reference instead of "Def"

regard

christian

AW:Using Set Analysis

Wed, 27 Apr 2011 13:26:03 GMT

Ok. I have created the variable varRecordType; when I select the RecordType I set this variable.

I have written sum( ${ RecordType = { $(=varRecordType) } } Amount), but it doesn't function.

AW:Using Set Analysis

rbecher — Wed, 27 Apr 2011 13:29:45 GMT

just try:

sum( ${ RecordType = {$(varRecordType) } } Amount) or sum( ${ RecordType = {"$(varRecordType)" } } Amount)

- Ralf

AW:Using Set Analysis

Wed, 27 Apr 2011 13:43:44 GMT

None of these solutions function and there is a syntax error (where are the < and > characters?).

Is there a sure documentation about set analysis?

AW:Using Set Analysis

rbecher — Wed, 27 Apr 2011 13:50:14 GMT

Sorry:

<blockquote><pre>sum( {$ <RecordType = {$(varRecordType) }> } Amount) or sum( {$ <RecordType = {"$(varRecordType)" }> } Amount)

- Ralf

AW:Using Set Analysis

Wed, 27 Apr 2011 14:02:18 GMT

Don't worry. I have already tried also these solutions without success!

Thanks

AW:Using Set Analysis

Wed, 27 Apr 2011 14:22:10 GMT

Ok, I've solved with sum({$< RecordType = {$(varRecordType)} > } Amount).

The variable isn't set correctly.

Thanks

AW:Using Set Analysis

Wed, 27 Apr 2011 14:33:49 GMT

Hello,

if I got you right, you do want to respect the selected RecordTypes in your chart with dim1= Year and and dim2=Month. And you are using a listbox with a concatenated string with "Year + Month + RecoredType". So just for fun:

sum( Amount)

Regards, Roland

AW:Using Set Analysis

Wed, 27 Apr 2011 16:00:03 GMT

Yes.