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

Set analysis - field value equal to other field

nboccassini — Fri, 21 Jan 2022 15:12:03 GMT

Hi all,

I have an app 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?

Re: Set analysis - field value equal to other field

Ksrinivasan — Sat, 22 Jan 2022 00:36:57 GMT

Hi, first you have to create one more year1 in table 2 with name of year, Second, Right join table 1 and table2. With reference of Year. Now you create a formula in set of year1 is not equal to '' empty. Result is your s.

Re: Set analysis - field value equal to other field

nboccassini — Mon, 24 Jan 2022 16:46:00 GMT

For other reason, I can't join the table (the real app in more complicated)

Re: Set analysis - field value equal to other field

vikasmahajan — Sat, 29 Jan 2022 13:14:20 GMT

Please try this :

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

reference : https://community.qlik.com/t5/QlikView-App-Dev/compare-2-fields-set-analysis/td-p/1183006

Hope this helps

Vikas

Re: Set analysis - field value equal to other field

nboccassini — Sat, 29 Jan 2022 15:55:45 GMT

Thanks Vikas,

but your solution works only if ther is ony one year1 for each year

Re: Set analysis - field value equal to other field

Digvijay_Singh — Sun, 30 Jan 2022 04:28:37 GMT

May be if possible, create composite key using loc and year in both the tables as in sample attached -