Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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?