topic Re: Set Analysis Expression in App Development

Set Analysis Expression

sona_sa — Tue, 21 Dec 2021 21:56:36 GMT

Hi Team, Below is my chart and pivot table. I have two list box, 1. Year Month and 2. Role

In My Pivot Table 3 dimension and 1 expression.

1 Category --> If(wildmatch(Role,'External*'),Role)

2. Sub Category

3. Year Month

Expression : Sum(Value)

Now suppose if I make any selection in Year Month or Role, Figure not affected in Pivot Table and Chart. So need expression for the same. Please find the attached QVW for more reference.

Re: Set Analysis Expression

GaryGiles — Tue, 11 May 2021 14:50:16 GMT

Are you trying to ignore selections made in Year Month and Role?

If so, you would use:

sum({$<[Year Month]=,[Role]=>} Value)

Re: Set Analysis Expression

sona_sa — Tue, 11 May 2021 15:04:15 GMT

For Year Month it is working but when I am making a selection for role it is not working. On selection of Year Month Below is output

On Role Selection Below is output :

Thanks

Re: Set Analysis Expression

sona_sa — Tue, 11 May 2021 15:20:02 GMT

Hi Gary,

Please find the attached QVW for refence.

Thanks