topic Re: Logic needed in QlikView https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19916#M789512 <HTML><HEAD></HEAD><BODY><P>i.e for ID = 1 you want only Active to be loaded as status in script?</P><P></P><P>Do you have any reference date column also?</P></BODY></HTML> Wed, 14 Feb 2018 06:15:03 GMT shiveshsingh 2018-02-14T06:15:03Z Logic needed https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19914#M789510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Below is my data structure</P><P></P><P>ID&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amt</P><P>1&nbsp;&nbsp;&nbsp; Active&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>1&nbsp;&nbsp;&nbsp; Completed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 211</P><P>2&nbsp;&nbsp;&nbsp; Active&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>3&nbsp;&nbsp;&nbsp; Completed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P></P><P>If ID has Active and Completed count only ID with Active else count other status...</P><P></P><P>I want the below output</P><P></P><P>ID&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amt</P><P>1&nbsp;&nbsp;&nbsp; Active&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P><SPAN style="font-size: 10pt;">2&nbsp;&nbsp;&nbsp; Active&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</SPAN></P><P>3&nbsp;&nbsp;&nbsp; Completed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P></P><P>Thank you much.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19914#M789510 apthansh 2020-11-25T16:16:04Z Re: Logic needed https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19915#M789511 <HTML><HEAD></HEAD><BODY><P>Like this you want</P></BODY></HTML> Wed, 14 Feb 2018 04:30:45 GMT https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19915#M789511 prma7799 2018-02-14T04:30:45Z Re: Logic needed https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19916#M789512 <HTML><HEAD></HEAD><BODY><P>i.e for ID = 1 you want only Active to be loaded as status in script?</P><P></P><P>Do you have any reference date column also?</P></BODY></HTML> Wed, 14 Feb 2018 06:15:03 GMT https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19916#M789512 shiveshsingh 2018-02-14T06:15:03Z Re: Logic needed https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19917#M789513 <HTML><HEAD></HEAD><BODY><P>This out put has 2 rows for ID 1..I only want Active ID if its both Active and Completed.</P></BODY></HTML> Wed, 14 Feb 2018 12:49:19 GMT https://community.qlik.com/t5/QlikView/Logic-needed/m-p/19917#M789513 apthansh 2018-02-14T12:49:19Z