topic Controlling context in set analysis in QlikView https://community.qlik.com/t5/QlikView/Controlling-context-in-set-analysis/m-p/1218320#M861392 <HTML><HEAD></HEAD><BODY><P>I have a requirement where I need the value from one category in a calculation for other categories. The total should be limited to that pivot table column. In the attached file I'm looking for Cat1Value to be 100 for Brand A and 300 for Brand B. I'm using</P><P><STRONG><STRONG></STRONG></STRONG></P><P>$(=Sum({ &lt;Category = {'Category 1'}&gt;} [Amount])) but I need to limit it to the current pivot table column. Is there a way to accomplish this? I won't be able to hard code the brand because they'll be different depending on current selections.</P><P></P><P>Appreciate any help.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Controlling context in set analysis https://community.qlik.com/t5/QlikView/Controlling-context-in-set-analysis/m-p/1218320#M861392 <HTML><HEAD></HEAD><BODY><P>I have a requirement where I need the value from one category in a calculation for other categories. The total should be limited to that pivot table column. In the attached file I'm looking for Cat1Value to be 100 for Brand A and 300 for Brand B. I'm using</P><P><STRONG><STRONG></STRONG></STRONG></P><P>$(=Sum({ &lt;Category = {'Category 1'}&gt;} [Amount])) but I need to limit it to the current pivot table column. Is there a way to accomplish this? I won't be able to hard code the brand because they'll be different depending on current selections.</P><P></P><P>Appreciate any help.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Controlling-context-in-set-analysis/m-p/1218320#M861392 2020-11-25T16:16:04Z Re: Controlling context in set analysis https://community.qlik.com/t5/QlikView/Controlling-context-in-set-analysis/m-p/1218321#M861393 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148845_Capture.PNG" style="height: auto;" /></P><P></P><P><STRONG>Sum(TOTAL &lt;Brand&gt;{ &lt;Category = {'Category 1'}&gt;} [Amount])</STRONG></P></BODY></HTML> Mon, 09 Jan 2017 17:21:10 GMT https://community.qlik.com/t5/QlikView/Controlling-context-in-set-analysis/m-p/1218321#M861393 sunny_talwar 2017-01-09T17:21:10Z Re: Controlling context in set analysis https://community.qlik.com/t5/QlikView/Controlling-context-in-set-analysis/m-p/1218322#M861394 <HTML><HEAD></HEAD><BODY><P>Just like that!</P><P></P><P>Thank you very much.</P></BODY></HTML> Mon, 09 Jan 2017 18:01:00 GMT https://community.qlik.com/t5/QlikView/Controlling-context-in-set-analysis/m-p/1218322#M861394 2017-01-09T18:01:00Z