topic New to skripting - sum if in QlikView https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135332#M888190 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>how to I count participants from a field called "age"?</P><P></P><P>I want to show the number of participants that have an "age" value via a KPI Diagram.</P><P></P><P>I know this is simple, too simple, but I am only now starting to look into skripting after I think I have explored all basic functionality.</P><P></P><P>Appreciate your feedback!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT florian890 2020-11-25T16:16:04Z New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135332#M888190 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>how to I count participants from a field called "age"?</P><P></P><P>I want to show the number of participants that have an "age" value via a KPI Diagram.</P><P></P><P>I know this is simple, too simple, but I am only now starting to look into skripting after I think I have explored all basic functionality.</P><P></P><P>Appreciate your feedback!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135332#M888190 florian890 2020-11-25T16:16:04Z Re: New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135333#M888191 <HTML><HEAD></HEAD><BODY><P>It would be helpful if you can provide more information and possible a sample with the expectation of the output you are looking to get. Difficult to know what you might be trying to get without much details</P><P></P><P><A href="https://community.qlik.com/docs/DOC-2380">QlikCommunity Tip: How to get answers to your post?</A></P></BODY></HTML> Sat, 03 Sep 2016 18:13:35 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135333#M888191 sunny_talwar 2016-09-03T18:13:35Z Re: New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135334#M888192 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">count({$&lt;age={"*"}&gt;} participants)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">hope this helps</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Marco<BR /></SPAN></P></BODY></HTML> Sat, 03 Sep 2016 21:29:08 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135334#M888192 MarcoWedel 2016-09-03T21:29:08Z Re: New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135335#M888193 <HTML><HEAD></HEAD><BODY><P>If you start with an extremely vague premise, you'll get wildly diverse responses. Probably none of them fit your bill from the start.</P><P></P><P>Maybe you should start by telling us in what form your source data will be made available (participants? age? What is the relation between these two fields? Where do they come from? Why don't all participants have an age, while <SPAN style="font-size: 13.3333px;">on average </SPAN>all 7 billion of us do have an age? What sort of QV model did you create up to this point? Can you post it here?) </P></BODY></HTML> Sat, 03 Sep 2016 22:45:52 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135335#M888193 Peter_Cammaert 2016-09-03T22:45:52Z Re: New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135336#M888194 <HTML><HEAD></HEAD><BODY><P>Oh - and the Excel concept SUMIF doesn't really exist in QV. But then I guess that we all agree on the fact that QV is way more advanced than Excel <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />. </P><P></P><P>Just joking.</P></BODY></HTML> Sat, 03 Sep 2016 22:48:32 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135336#M888194 Peter_Cammaert 2016-09-03T22:48:32Z Re: New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135337#M888195 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, Marco! Highly appreciated</P></BODY></HTML> Tue, 06 Sep 2016 09:06:36 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135337#M888195 florian890 2016-09-06T09:06:36Z Re: New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135338#M888196 <HTML><HEAD></HEAD><BODY><P>I should have read this beforehand, will improve! Thank you for pointing me the right directtion, Sunny T</P></BODY></HTML> Tue, 06 Sep 2016 09:08:31 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135338#M888196 florian890 2016-09-06T09:08:31Z Re: New to skripting - sum if https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135339#M888197 <HTML><HEAD></HEAD><BODY><P>you're welcome</P><P></P><P>please close your thread if your question is answered:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 06 Sep 2016 20:45:08 GMT https://community.qlik.com/t5/QlikView/New-to-skripting-sum-if/m-p/1135339#M888197 MarcoWedel 2016-09-06T20:45:08Z