topic Calculate the billing Consistency Region Wise in QlikView https://community.qlik.com/t5/QlikView/Calculate-the-billing-Consistency-Region-Wise/m-p/8526#M783719 <HTML><HEAD></HEAD><BODY><P>Hi,<IMG __jive_id="195999" alt="Report.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195999_Report.jpg" style="max-width: 620px; height: auto;" /></P><P>I have 4 fields,</P><P>region, Ship_To_Code, Date, Sales.</P><P>Calculate the billing Consistency Region Wise -</P><P>Sales more than 1-Lakh in last 3 month on the basis of Ship_To_Code.</P><UL><LI>If any Ship_To_Code is billing for more than 1-Lakh in last 3 months for 1 time, then it should be represent in column of 1/3.</LI><LI>If any Ship_To_Code is billing for more than 1-Lakh in last 3 months 2 times, then it should be represent in column of&nbsp; 2/3.</LI><LI>If any Ship_To_Code is billing for more than 1-Lakh in last 3 months 3 times, then it should be represent in column of&nbsp; 3/3.</LI></UL><P></P><P>I need to calculate it on back-end.</P><P>Please Find the attachment.</P><P>Thanks in Advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT simran_mann 2020-11-25T16:16:04Z Calculate the billing Consistency Region Wise https://community.qlik.com/t5/QlikView/Calculate-the-billing-Consistency-Region-Wise/m-p/8526#M783719 <HTML><HEAD></HEAD><BODY><P>Hi,<IMG __jive_id="195999" alt="Report.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195999_Report.jpg" style="max-width: 620px; height: auto;" /></P><P>I have 4 fields,</P><P>region, Ship_To_Code, Date, Sales.</P><P>Calculate the billing Consistency Region Wise -</P><P>Sales more than 1-Lakh in last 3 month on the basis of Ship_To_Code.</P><UL><LI>If any Ship_To_Code is billing for more than 1-Lakh in last 3 months for 1 time, then it should be represent in column of 1/3.</LI><LI>If any Ship_To_Code is billing for more than 1-Lakh in last 3 months 2 times, then it should be represent in column of&nbsp; 2/3.</LI><LI>If any Ship_To_Code is billing for more than 1-Lakh in last 3 months 3 times, then it should be represent in column of&nbsp; 3/3.</LI></UL><P></P><P>I need to calculate it on back-end.</P><P>Please Find the attachment.</P><P>Thanks in Advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-the-billing-Consistency-Region-Wise/m-p/8526#M783719 simran_mann 2020-11-25T16:16:04Z