topic Count in QlikView https://community.qlik.com/t5/QlikView/Count/m-p/813174#M1025768 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt;" width="128"><TBODY><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; width: 48pt;" width="64">week</TD><TD class="xl64" style="border-left: none; width: 48pt;" width="64">yearweek</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201405</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140105</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201406</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140106</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201406</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140206</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201407</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140207</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201408</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140208</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201409</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140209</TD></TR></TBODY></TABLE><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80869_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>How to find out count of those Yearweek which come twice as per week.. in script ?</P><P></P><P>In this example 20140106 and 20140206 comes 2 time in 201406 week..</P><P>so how to write code in script.</P></BODY></HTML> Mon, 16 Mar 2015 17:39:44 GMT 2015-03-16T17:39:44Z Count https://community.qlik.com/t5/QlikView/Count/m-p/813174#M1025768 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt;" width="128"><TBODY><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; width: 48pt;" width="64">week</TD><TD class="xl64" style="border-left: none; width: 48pt;" width="64">yearweek</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201405</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140105</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201406</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140106</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201406</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140206</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201407</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140207</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201408</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140208</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl63" height="20" style="height: 15.0pt; border-top: none;">201409</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20140209</TD></TR></TBODY></TABLE><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80869_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>How to find out count of those Yearweek which come twice as per week.. in script ?</P><P></P><P>In this example 20140106 and 20140206 comes 2 time in 201406 week..</P><P>so how to write code in script.</P></BODY></HTML> Mon, 16 Mar 2015 17:39:44 GMT https://community.qlik.com/t5/QlikView/Count/m-p/813174#M1025768 2015-03-16T17:39:44Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/813175#M1025769 <HTML><HEAD></HEAD><BODY><P><STRONG>RESULT</STRONG></P><P><STRONG><IMG alt="1.jpg" class="image-1 jive-image" height="137" src="https://community.qlik.com/legacyfs/online/80872_1.jpg" style="height: 136.892201834862px; width: 345px;" width="345" /><BR /></STRONG></P><P></P><P><STRONG>SCRIPT</STRONG></P><P><EM>source:</EM></P><P><EM>load * inline [</EM></P><P><EM>week, yearweek</EM></P><P><EM>201405, 20140105</EM></P><P><EM>201406, 20140106</EM></P><P><EM>201406, 20140206</EM></P><P><EM>201407, 20140207</EM></P><P><EM>201408, 20140208</EM></P><P><EM>201409, 20140209</EM></P><P><EM>];</EM></P><P></P><P><EM>load</EM></P><P><EM>&nbsp; week, if(count(distinct yearweek)&gt;1, 1, 0) as flagmorethanoncexweek</EM></P><P><EM>Resident source</EM></P><P><EM>group by week;</EM></P></BODY></HTML> Mon, 16 Mar 2015 17:46:22 GMT https://community.qlik.com/t5/QlikView/Count/m-p/813175#M1025769 maxgro 2015-03-16T17:46:22Z