Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nboccassini
Partner - Creator
Partner - Creator

Set analysis - field value equal to other field

Hi all,

I have an app (attached) with two tables

nboccassini_0-1642769557851.png

 

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?

 

 

Labels (2)
2 Replies
anat
Master
Master

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

nboccassini
Partner - Creator
Partner - Creator
Author

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)

nboccassini_0-1643042836245.png

any suggest?