topic Re: Count Dates by Week with Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920729#M983318 <HTML><HEAD></HEAD><BODY><P>see attachment</P></BODY></HTML> Wed, 12 Aug 2015 10:15:16 GMT maxgro 2015-08-12T10:15:16Z Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920721#M983310 <HTML><HEAD></HEAD><BODY><P>Hi people,</P><P></P><P>I would like to know if there is anyway for me to count the amount of dates in a week using set analysis. For example, I have this table of values:</P><P></P><TABLE border="1" class="jiveBorder" height="191.39999997615814" style="border: 1px solid rgb(0, 0, 0); width: 128.399999976158px; height: 186.399999976158px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Week</STRONG></TH></TR><TR><TD style="padding: 2px;">01/01/2013</TD><TD style="padding: 2px;">2013/01</TD></TR><TR><TD style="padding: 2px;">07/10/2013</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">2013/41</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">09/10/2013</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">2013/41</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">10/10/2013</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">2013/41</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">10/10/2013</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">2013/41</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">10/10/2013</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">2013/41</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">11/10/2013</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">2013/41</SPAN></TD></TR></TBODY></TABLE><P></P><P>The results I need for this example are:</P><P></P><P>For Week -&gt; 2013/01 the count number would be 1.</P><P>And for Week -&gt; 2013/41 the count number would be 6.</P><P></P><P>How can I do this in a simple and clean way for me to understand? Bare in mind that I'm a begginer developer in both QlikView and Qlik Sense, just started a month ago.</P><P></P><P>Thanks for the help, Miguel.</P></BODY></HTML> Wed, 12 Aug 2015 09:48:38 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920721#M983310 miguelbraga 2015-08-12T09:48:38Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920722#M983311 <HTML><HEAD></HEAD><BODY><P>If you add Week as a dimension and Count(Week) as your expression, you should get the result you are expecting to see.</P></BODY></HTML> Wed, 12 Aug 2015 09:50:15 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920722#M983311 sunny_talwar 2015-08-12T09:50:15Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920723#M983312 <HTML><HEAD></HEAD><BODY><P>count(TOTAL &lt;Week&gt; distinct Date)</P></BODY></HTML> Wed, 12 Aug 2015 09:50:59 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920723#M983312 maxgro 2015-08-12T09:50:59Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920724#M983313 <HTML><HEAD></HEAD><BODY><P>This:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95754_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 12 Aug 2015 09:56:01 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920724#M983313 sunny_talwar 2015-08-12T09:56:01Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920725#M983314 <HTML><HEAD></HEAD><BODY><P>I've done this solution and it seems that the numbers <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">for Week -&gt; 2013/01 is 5 </SPAN>and for Week -&gt; 2013/41 is 5.</P></BODY></HTML> Wed, 12 Aug 2015 09:56:35 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920725#M983314 miguelbraga 2015-08-12T09:56:35Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920726#M983315 <HTML><HEAD></HEAD><BODY><P>Please try this</P></BODY></HTML> Wed, 12 Aug 2015 10:03:26 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920726#M983315 sasiparupudi1 2015-08-12T10:03:26Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920727#M983316 <HTML><HEAD></HEAD><BODY><P>With this solution I could get my answer right!</P><P></P><P>Many thanks Mr. Sasidhar Parupudi. Have a nice week <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 12 Aug 2015 10:07:33 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920727#M983316 miguelbraga 2015-08-12T10:07:33Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920728#M983317 <HTML><HEAD></HEAD><BODY><P>Hi Braga Miguel,</P><P></P><P>Your most welcome ,you too have a nice week.</P><P></P><P>Sasi</P></BODY></HTML> Wed, 12 Aug 2015 10:09:25 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920728#M983317 sasiparupudi1 2015-08-12T10:09:25Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920729#M983318 <HTML><HEAD></HEAD><BODY><P>see attachment</P></BODY></HTML> Wed, 12 Aug 2015 10:15:16 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920729#M983318 maxgro 2015-08-12T10:15:16Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920730#M983319 <HTML><HEAD></HEAD><BODY><P>count(Total&lt;Week&gt;Week)</P></BODY></HTML> Wed, 12 Aug 2015 10:15:19 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920730#M983319 tyagishaila 2015-08-12T10:15:19Z Re: Count Dates by Week with Set Analysis https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920731#M983320 <HTML><HEAD></HEAD><BODY><P>I'll analyse this solution too, thanks Massimo Grossi. I'll keep in touch <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Wed, 12 Aug 2015 10:34:11 GMT https://community.qlik.com/t5/QlikView/Count-Dates-by-Week-with-Set-Analysis/m-p/920731#M983320 miguelbraga 2015-08-12T10:34:11Z