Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

micheledenardi
Valued Contributor

Set analysis and selection on the same field

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])

1 Solution

Accepted Solutions

Re: Set analysis and selection on the same field

Try it with:

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

- Marcus

2 Replies
amartinez35
Valued Contributor

Re: Set analysis and selection on the same field

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

Try it with:

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

- Marcus

Community Browser