topic Re: How to take actual values, not count? in QlikView https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457759#M435522 <HTML><HEAD></HEAD><BODY><P>Usually what we do in such cases, Count(If(D1&gt; xyz and D2 &lt; abc,ID)) then result will be count(ID). But now I want to print all ID comes under dates D1 and D2.</P></BODY></HTML> Wed, 03 Jan 2018 05:57:39 GMT Shubham_Deshmukh 2018-01-03T05:57:39Z How to take actual values, not count? https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457756#M435519 <HTML><HEAD></HEAD><BODY><P>I have some IDs and I want to show that values(ID) I am doing something like , If(D1&gt; xyz and D2 &lt; abc,ID) But I know this is wrong way. Can any1 tell me how to get IDs?</P></BODY></HTML> Wed, 03 Jan 2018 05:51:54 GMT https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457756#M435519 Shubham_Deshmukh 2018-01-03T05:51:54Z Re: How to take actual values, not count? https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457757#M435520 <HTML><HEAD></HEAD><BODY><P>Could you explain a bit more with a sample data set may be?</P></BODY></HTML> Wed, 03 Jan 2018 05:54:51 GMT https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457757#M435520 tresB 2018-01-03T05:54:51Z Re: How to take actual values, not count? https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457758#M435521 <HTML><HEAD></HEAD><BODY><P>Please share some sample data .... with expected output...</P></BODY></HTML> Wed, 03 Jan 2018 05:56:14 GMT https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457758#M435521 prma7799 2018-01-03T05:56:14Z Re: How to take actual values, not count? https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457759#M435522 <HTML><HEAD></HEAD><BODY><P>Usually what we do in such cases, Count(If(D1&gt; xyz and D2 &lt; abc,ID)) then result will be count(ID). But now I want to print all ID comes under dates D1 and D2.</P></BODY></HTML> Wed, 03 Jan 2018 05:57:39 GMT https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457759#M435522 Shubham_Deshmukh 2018-01-03T05:57:39Z Re: How to take actual values, not count? https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457760#M435523 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Concat</STRONG>(<STRONG>Distinct</STRONG> If(D1&gt; xyz and D2 &lt; abc,ID) <STRONG>, ','</STRONG>)</SPAN></P></BODY></HTML> Wed, 03 Jan 2018 06:00:53 GMT https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457760#M435523 tresB 2018-01-03T06:00:53Z Re: How to take actual values, not count? https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457761#M435524 <HTML><HEAD></HEAD><BODY><P>Thanks Tresesco, I will try.</P></BODY></HTML> Wed, 03 Jan 2018 06:29:51 GMT https://community.qlik.com/t5/QlikView/How-to-take-actual-values-not-count/m-p/1457761#M435524 Shubham_Deshmukh 2018-01-03T06:29:51Z