1.0Bitmetrichttps://www.bitmetric.nl/nl/Barry Harmsenhttps://www.bitmetric.nl/nl/author/barry/Using the GROUP BY clause in Qlik Sense - Bitmetricrich600338<blockquote class="wp-embedded-content" data-secret="KdGnIApSNG"><a href="https://www.bitmetric.nl/nl/blog/qlik-group-by/">Using the GROUP BY clause in Qlik Sense</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.bitmetric.nl/nl/blog/qlik-group-by/embed/#?secret=KdGnIApSNG" width="600" height="338" title="“Using the GROUP BY clause in Qlik Sense” — Bitmetric" data-secret="KdGnIApSNG" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://www.bitmetric.nl/wp-includes/js/wp-embed.min.js
/* ]]> */
</script>
https://www.bitmetric.nl/wp-content/uploads/2022/06/20220622-Friday-Qlik-Test-Prep-Solution-GROUP-BY.png1060710When using aggregation functions in Qlik script we often need to use the GROUP BY clause to define on which level the data should be calculated. This article shows you how.