topic Re: Set analysis - field value equal to other field in QlikView

Set analysis - field value equal to other field

nboccassini — Fri, 21 Jan 2022 13:59:00 GMT

Hi all,

I have an app (attached) with two tables

I need a pivot that sum the value only for loc that have year=year1. The pivot must have type and year as dimensions.

How can I make it ? Using set analysis?

anat — Mon, 24 Jan 2022 04:43:31 GMT

=sum({$<value= {"=year = year1"}>}value)

nboccassini — Mon, 24 Jan 2022 16:48:51 GMT

Thanks Anat, but it works only if loc has only one year_1.

as you can see, the expression doesn't work for loc=2 (and for year=2019)

any suggest?