topic Re: How make filter sum of two attributes? in QlikView https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778566#M1047376 <HTML><HEAD></HEAD><BODY><P>My solution would be:</P><P></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(<STRONG style="font-style: inherit;">If(</STRONG> [1Order] + [2Order] =1, ([1Order] + [2Order]))</STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(<STRONG style="font-style: inherit;">If(</STRONG> [1Order] + [2Order] =&gt;2 and <STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[1Order] + [2Order] &lt;=4</STRONG>, ([1Order] + [2Order]))</STRONG></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(<STRONG style="font-style: inherit;">If(</STRONG> [1Order] + [2Order] &gt;4, ([1Order] + [2Order]))</STRONG></STRONG></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></STRONG></STRONG></P></BODY></HTML> Thu, 06 Nov 2014 10:59:17 GMT 2014-11-06T10:59:17Z How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778561#M1047371 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For instance, I have table shown like below:</P><P></P><P>Month&nbsp;&nbsp;&nbsp;&nbsp; 1Order&nbsp; 2Order </P><P>Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>March&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Aug&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>I want filter three different filter for three expression.</P><P></P><P><STRONG>expression 1:&nbsp; [1Order] + [2Order] = 1</STRONG></P><P><STRONG>expression 2:&nbsp; [1Order] + [2Order] =&gt; 2&nbsp; and&nbsp; [1Order] + [2Order] &lt;=4</STRONG></P><P><STRONG>expression 3:&nbsp; [1Order] + [2Order] &gt; 4 </STRONG></P><P></P><P>I tried in the expression for expression 1 <STRONG>Sum({$&lt; [1Order] + [2Order] ={'1'}&gt;} ([1Order] + [2Order]))</STRONG>&nbsp; but it doesn't not work.</P><P></P><P>I have solution in the data model&nbsp; [1Order] + [2Order] as 3Order</P><P>then expression would be Sum({$&lt; [3Order] ={'1'}&gt;} [3Order])</P><P></P><P>My aim want to do this in set expression.</P><P></P><P>Best,</P><P>Robert</P></BODY></HTML> Thu, 06 Nov 2014 10:33:54 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778561#M1047371 2014-11-06T10:33:54Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778562#M1047372 <HTML><HEAD></HEAD><BODY><P>What is your dimension ?</P></BODY></HTML> Thu, 06 Nov 2014 10:37:13 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778562#M1047372 MK_QSL 2014-11-06T10:37:13Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778563#M1047373 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">My original data like this below and <STRONG>my dimension is month.</STRONG>&nbsp;&nbsp; </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; phone&nbsp;&nbsp;&nbsp; 1Order&nbsp; 2Order</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Jan-2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 956&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Feb -2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 456&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">March-2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 989&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Aug -2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 765&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Indeed, i have data since march-2013 till today. </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Best,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Robert</P></BODY></HTML> Thu, 06 Nov 2014 10:43:16 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778563#M1047373 2014-11-06T10:43:16Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778564#M1047374 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(<STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(</STRONG> [1Order] + [2Order] =1, ([1Order] + [2Order]))</STRONG></P></BODY></HTML> Thu, 06 Nov 2014 10:47:13 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778564#M1047374 anbu1984 2014-11-06T10:47:13Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778565#M1047375 <HTML><HEAD></HEAD><BODY><P>Thanks ... </P></BODY></HTML> Thu, 06 Nov 2014 10:56:43 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778565#M1047375 2014-11-06T10:56:43Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778566#M1047376 <HTML><HEAD></HEAD><BODY><P>My solution would be:</P><P></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(<STRONG style="font-style: inherit;">If(</STRONG> [1Order] + [2Order] =1, ([1Order] + [2Order]))</STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(<STRONG style="font-style: inherit;">If(</STRONG> [1Order] + [2Order] =&gt;2 and <STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[1Order] + [2Order] &lt;=4</STRONG>, ([1Order] + [2Order]))</STRONG></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(<STRONG style="font-style: inherit;">If(</STRONG> [1Order] + [2Order] &gt;4, ([1Order] + [2Order]))</STRONG></STRONG></STRONG></P><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></STRONG></STRONG></P></BODY></HTML> Thu, 06 Nov 2014 10:59:17 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778566#M1047376 2014-11-06T10:59:17Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778567#M1047377 <HTML><HEAD></HEAD><BODY><P>Your question was, you want to get this in SET EXPRESSION !</P></BODY></HTML> Thu, 06 Nov 2014 11:00:44 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778567#M1047377 MK_QSL 2014-11-06T11:00:44Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778568#M1047378 <HTML><HEAD></HEAD><BODY><P>Yes. My aim want to be do in the expression not in the data model.</P></BODY></HTML> Thu, 06 Nov 2014 11:03:47 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778568#M1047378 2014-11-06T11:03:47Z Re: How make filter sum of two attributes? https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778569#M1047380 <HTML><HEAD></HEAD><BODY><P>My understanding was you want as Set Analysis and not using IF... But any how, you got your required answer...</P><P>Cheers !</P></BODY></HTML> Thu, 06 Nov 2014 11:07:30 GMT https://community.qlik.com/t5/QlikView/How-make-filter-sum-of-two-attributes/m-p/778569#M1047380 MK_QSL 2014-11-06T11:07:30Z