topic Set analysis and selection on the same field in App Development

Set analysis and selection on the same field

micheledenardi — Wed, 20 Dec 2017 16:02:20 GMT

Good evening everyone,

using the following set analysis expression i'm retriving the sum of report hours for request 69,70,71....268.

But i select one request number, for ex 71, the table does not reflect the selections and continue to show the sum() al all request number of the set analysis.... how to fix ?

Sum({$<[Request Number]={69,70,71,72,73,74,75,76,176,197,255,264,268}>} [Report Hours])

Re: Set analysis and selection on the same field

Aurelien_Martinez — Wed, 20 Dec 2017 16:15:10 GMT

Hi,

You can create a new field like [Request Type] and use it in set analysis.

for example:

MyTable:

LOAD *

INLINE [

Request Number, type

69, a

70, a

71, b

72, b

];

Sum({$<type={'A'}>} [Request Hours])

Aurélien

Re: Set analysis and selection on the same field

marcus_sommer — Wed, 20 Dec 2017 16:16:15 GMT

Try it with:

Sum({$<[Request Number]*={69,70,71,72,73,74,75,76,176,197,255,264,268}>} [Report Hours])

- Marcus