topic Re: Find the value excluded in QlikView https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323360#M831523 <HTML><HEAD></HEAD><BODY><P>But value must be 600 i got by this formula 1300 , Its wrong</P></BODY></HTML> Tue, 20 Jun 2017 12:20:19 GMT Anonymous 2017-06-20T12:20:19Z Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323355#M831518 <HTML><HEAD></HEAD><BODY><P>hello everyone,</P><P></P><P>I have to find the excluded value.</P><P>Ex:</P><P>Year</P><P>2014,2015</P><P></P><P>Region:r1,r2,r3,r4</P><P></P><P>Sales :10,20,30,40,50</P><P></P><P>Once i click on year (2015)I have to excl</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323355#M831518 Anonymous 2020-11-25T16:16:04Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323356#M831519 <HTML><HEAD></HEAD><BODY><P>Could you please explain little bit more?</P></BODY></HTML> Tue, 20 Jun 2017 12:05:32 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323356#M831519 prma7799 2017-06-20T12:05:32Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323357#M831520 <HTML><HEAD></HEAD><BODY><P>What is your table structure and what is that you are expecting to exclude the value? </P></BODY></HTML> Tue, 20 Jun 2017 12:07:21 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323357#M831520 vishsaggi 2017-06-20T12:07:21Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323358#M831521 <HTML><HEAD></HEAD><BODY><P>My table is,</P><P>Year&nbsp; Region Sales </P><P>2014&nbsp; r1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>2015&nbsp; r2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40</P><P></P><P>When i click on 2015, r4 value will be excluded and only r1,r2,r3 will show with sales.</P><P></P><P>I hope it clear</P></BODY></HTML> Tue, 20 Jun 2017 12:10:29 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323358#M831521 Anonymous 2017-06-20T12:10:29Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323359#M831522 <HTML><HEAD></HEAD><BODY><P>Please try like this </P><P></P><P>sum({1&lt;Region -= {'r4'}&gt;}Sales)</P></BODY></HTML> Tue, 20 Jun 2017 12:15:57 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323359#M831522 prma7799 2017-06-20T12:15:57Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323360#M831523 <HTML><HEAD></HEAD><BODY><P>But value must be 600 i got by this formula 1300 , Its wrong</P></BODY></HTML> Tue, 20 Jun 2017 12:20:19 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323360#M831523 Anonymous 2017-06-20T12:20:19Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323361#M831524 <HTML><HEAD></HEAD><BODY><P>What is logic of value 600 and what is year for&nbsp; r3&nbsp; and&nbsp;&nbsp; 40 you haven't mention year for this </P></BODY></HTML> Tue, 20 Jun 2017 12:22:00 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323361#M831524 prma7799 2017-06-20T12:22:00Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323362#M831525 <HTML><HEAD></HEAD><BODY><P>The value i have like :</P><P>r1&nbsp; r2 r3&nbsp; r4</P><P>100 200 100 400</P><P>200 400 300 200 </P><P></P><P>The value are shown above</P></BODY></HTML> Tue, 20 Jun 2017 12:26:53 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323362#M831525 Anonymous 2017-06-20T12:26:53Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323363#M831526 <HTML><HEAD></HEAD><BODY><P>Do you mean r4 should be excluded only when you select 2015 or from the whole table expression?</P></BODY></HTML> Tue, 20 Jun 2017 12:31:34 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323363#M831526 vishsaggi 2017-06-20T12:31:34Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323364#M831527 <HTML><HEAD></HEAD><BODY><P>correct</P></BODY></HTML> Tue, 20 Jun 2017 12:32:22 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323364#M831527 Anonymous 2017-06-20T12:32:22Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323365#M831528 <HTML><HEAD></HEAD><BODY><P>IF yes, then you can write like in your expression</P><P></P><P>= IF(GetFieldSelections(Year) = '2015', Sum({&lt;Region -= {'r4'} &gt;} Sales), Sum(Sales))</P></BODY></HTML> Tue, 20 Jun 2017 12:34:22 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323365#M831528 vishsaggi 2017-06-20T12:34:22Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323366#M831529 <HTML><HEAD></HEAD><BODY><P>How to put in Straight table , I have Current year previous year and third filed is Excluded value.</P></BODY></HTML> Tue, 20 Jun 2017 12:45:02 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323366#M831529 Anonymous 2017-06-20T12:45:02Z Re: Find the value excluded https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323367#M831530 <HTML><HEAD></HEAD><BODY><P>Can you share your sample app you are working on? I am quite confused what you are looking for and can you put down the values in an excel sheet your expected output?</P></BODY></HTML> Tue, 20 Jun 2017 13:39:15 GMT https://community.qlik.com/t5/QlikView/Find-the-value-excluded/m-p/1323367#M831530 vishsaggi 2017-06-20T13:39:15Z