topic Re: Set Analysis: to Show Common Stores between two consecutive months in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103372#M765160 <HTML><HEAD></HEAD><BODY><P>no I cant due to security reasons</P></BODY></HTML> Tue, 03 Jul 2018 09:38:50 GMT Anonymous 2018-07-03T09:38:50Z Set Analysis: to Show Common Stores between two consecutive months https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103368#M765156 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to show only common stores between two consecutive months .</P><P>Jan to Feb, Feb to March, March to April and so on ... using set analysis..</P><P></P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>YearMonth</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stores OverAll</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>#Common Stores</STRONG></TH></TR><TR><TD style="padding: 2px;">201801</TD><TD style="padding: 2px;">699</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">201802</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">201803</TD><TD style="padding: 2px;">700</TD><TD style="padding: 2px;">500</TD></TR></TBODY></TABLE><P>MonthNum: 1,2 3,.....</P><P></P><P></P><P>=count(Distinct {&lt;MonthNum={'$(=vCurrentMonth)' or MonthNum={'$(=vLastMonth)'&gt;}&gt;}StoreCode)</P><P></P><P>Please suggest</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103368#M765156 Anonymous 2020-11-25T16:16:04Z Re: Set Analysis: to Show Common Stores between two consecutive months https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103369#M765157 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one idea :</P><P></P><P>make a pivot table with yearmonth and storecode (in horizontal)</P><P>then expression :</P><P>above(count(distinct storecode))&nbsp; // storecode present prior month</P><P>and you sum it</P><P></P><P>regards</P></BODY></HTML> Tue, 03 Jul 2018 08:22:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103369#M765157 ogautier62 2018-07-03T08:22:43Z Re: Set Analysis: to Show Common Stores between two consecutive months https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103370#M765158 <HTML><HEAD></HEAD><BODY><P>can you provide a sample</P></BODY></HTML> Tue, 03 Jul 2018 08:45:34 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103370#M765158 Anonymous 2018-07-03T08:45:34Z Re: Set Analysis: to Show Common Stores between two consecutive months https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103371#M765159 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Can you attach the sample data and expected result?</SPAN></P></BODY></HTML> Tue, 03 Jul 2018 09:11:34 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103371#M765159 qlikviewwizard 2018-07-03T09:11:34Z Re: Set Analysis: to Show Common Stores between two consecutive months https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103372#M765160 <HTML><HEAD></HEAD><BODY><P>no I cant due to security reasons</P></BODY></HTML> Tue, 03 Jul 2018 09:38:50 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103372#M765160 Anonymous 2018-07-03T09:38:50Z Re: Set Analysis: to Show Common Stores between two consecutive months https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103373#M765161 <HTML><HEAD></HEAD><BODY><P>You can send some sample data instead of original data.</P></BODY></HTML> Tue, 03 Jul 2018 10:08:24 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-to-Show-Common-Stores-between-two-consecutive/m-p/103373#M765161 qlikviewwizard 2018-07-03T10:08:24Z