topic Re: Help with logic in QlikView https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843425#M296315 <HTML><HEAD></HEAD><BODY><P>Ya. Please provide the sample data.</P></BODY></HTML> Thu, 16 Apr 2015 06:25:14 GMT 2015-04-16T06:25:14Z Help with logic https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843424#M296314 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a scenario where I have a list of Partners for an organization and their particular sales data according to Year-Quarter.</P><P>I want to find out a list of <STRONG>'Net New Dormant'</STRONG> partners for the Year-Quarter selected. The logic for finding <STRONG>'Dormant'</STRONG> partners for the select Year-Quarter is that if the Partners has not had any sales in the Previous 2 quarters and current quarter, but had sales in the 7 quarter before the Previous 2 quarters, then it is a <STRONG>'Dormant'</STRONG> partner in the selected Year-Quarter.</P><P>For e.g.:</P><P>Selected Year-Quarter - <STRONG>'2014 Q4'</STRONG></P><P>Sales in Quarter <STRONG>'2014 Q4', '2014 Q3', '2014 Q2'</STRONG> = 0(zero)</P><P>Sales in Quarters <STRONG>'2012 Q3'-'2014 Q1'</STRONG> is not 0(zero)</P><P></P><P>Now I want to find the <STRONG>'Net New Dormant'</STRONG> which basically tells me how many NEW dormant partners I have in the <SPAN style="font-size: 13.3333330154419px;">selected Year-Quarter, which basically means the partner was not dormant in the previous Year-Quarter but it is in the <SPAN style="font-size: 13.3333330154419px;">selected Year-Quarter.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">It employs the same Dormant logic for the calculation.</SPAN></P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">If need I can provide a sample data qvw.</SPAN></P><P></P><P>Thanks,</P><P>Abhinava</P></BODY></HTML> Thu, 16 Apr 2015 06:23:25 GMT https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843424#M296314 er_abhichandra 2015-04-16T06:23:25Z Re: Help with logic https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843425#M296315 <HTML><HEAD></HEAD><BODY><P>Ya. Please provide the sample data.</P></BODY></HTML> Thu, 16 Apr 2015 06:25:14 GMT https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843425#M296315 2015-04-16T06:25:14Z Re: Help with logic https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843426#M296316 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Attached is the sample data file.</P><P></P><P>Thanks,</P><P>Abhinava !</P></BODY></HTML> Thu, 16 Apr 2015 07:05:57 GMT https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843426#M296316 er_abhichandra 2015-04-16T07:05:57Z Re: Help with logic https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843427#M296317 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have developed a Solution for this. </P><P></P><P>Regards,</P><P>Abhinava</P></BODY></HTML> Fri, 17 Apr 2015 07:46:28 GMT https://community.qlik.com/t5/QlikView/Help-with-logic/m-p/843427#M296317 er_abhichandra 2015-04-17T07:46:28Z