topic Field Intersections in QlikView https://community.qlik.com/t5/QlikView/Field-Intersections/m-p/169891#M40516 <HTML><HEAD></HEAD><BODY><P>I need a way to sum conditional data in a clause when a certain condition applies. For example, I have two fields: 1. Major Category, 2. Journal Type. The summation needs to occur when [Major Category].Sales and [Journal Type].Net intersect. That intersection when both instances occur, will equal this years Net Sales. From there I will need to create a variance percent that will show year over year change. Any suggestions?</P></BODY></HTML> Fri, 18 Mar 2011 19:47:14 GMT 2011-03-18T19:47:14Z Field Intersections https://community.qlik.com/t5/QlikView/Field-Intersections/m-p/169891#M40516 <HTML><HEAD></HEAD><BODY><P>I need a way to sum conditional data in a clause when a certain condition applies. For example, I have two fields: 1. Major Category, 2. Journal Type. The summation needs to occur when [Major Category].Sales and [Journal Type].Net intersect. That intersection when both instances occur, will equal this years Net Sales. From there I will need to create a variance percent that will show year over year change. Any suggestions?</P></BODY></HTML> Fri, 18 Mar 2011 19:47:14 GMT https://community.qlik.com/t5/QlikView/Field-Intersections/m-p/169891#M40516 2011-03-18T19:47:14Z Field Intersections https://community.qlik.com/t5/QlikView/Field-Intersections/m-p/169892#M40517 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean when you say "intersect" - when Major Category = 'Sales' and Journal Type = 'Net' ?</P><P>Then, if you need to aggregate numbers in the UI, you can use Set Analysis:</P><P>sum( {&lt;[Major Category]= {'Sales'}, [Journal Type]={'Net'}&gt;} MyValue)</P><P></P></BODY></HTML> Fri, 18 Mar 2011 19:52:46 GMT https://community.qlik.com/t5/QlikView/Field-Intersections/m-p/169892#M40517 Oleg_Troyansky 2011-03-18T19:52:46Z