topic Getting insights from sales data: Qlikview Sense in QlikView https://community.qlik.com/t5/QlikView/Getting-insights-from-sales-data-Qlikview-Sense/m-p/1104452#M463053 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new to Qlikview Sense. Can someone guide me on how to write queries/ logic to get insights like below, I am attaching a sample format of my data.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 8pt;">1. Productive Store</SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M (Past 1 month)</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M (Past 3 months)</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month (OR this year current month vs last year same month)</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 2</SPAN><SPAN style="color: #000000; font-family: Calibri;">. Brand Distribution - Brand billed in how many stores</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 3</SPAN><SPAN style="color: #000000; font-family: Calibri;">. SKU Distribution</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 4</SPAN><SPAN style="color: #000000; font-family: Calibri;">. Avg Purchase Qty of SKU</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 5</SPAN><SPAN style="color: #000000; font-family: Calibri;">. Comparison in bar charts</SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) this year vs last year same period</SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) month vs target</SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) H1 vs target</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) year vs target</SPAN></SPAN><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></P></BODY></HTML> Mon, 01 Aug 2016 15:59:38 GMT 2016-08-01T15:59:38Z Getting insights from sales data: Qlikview Sense https://community.qlik.com/t5/QlikView/Getting-insights-from-sales-data-Qlikview-Sense/m-p/1104452#M463053 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new to Qlikview Sense. Can someone guide me on how to write queries/ logic to get insights like below, I am attaching a sample format of my data.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 8pt;">1. Productive Store</SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M (Past 1 month)</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M (Past 3 months)</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month (OR this year current month vs last year same month)</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 2</SPAN><SPAN style="color: #000000; font-family: Calibri;">. Brand Distribution - Brand billed in how many stores</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 3</SPAN><SPAN style="color: #000000; font-family: Calibri;">. SKU Distribution</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 4</SPAN><SPAN style="color: #000000; font-family: Calibri;">. Avg Purchase Qty of SKU</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) P1M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) P3M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) P12M</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; 5</SPAN><SPAN style="color: #000000; font-family: Calibri;">. Comparison in bar charts</SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">a) this year vs last year same period</SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">b) month vs target</SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">c) H1 vs target</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="font-family: Calibri;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) year vs target</SPAN></SPAN><SPAN style="color: #000000; font-family: Times New Roman;">&nbsp; </SPAN></SPAN></P><P><SPAN style="font-family: Calibri; font-size: 8pt;"><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #000000;">d) how to compare vs previous month</SPAN></SPAN></P></BODY></HTML> Mon, 01 Aug 2016 15:59:38 GMT https://community.qlik.com/t5/QlikView/Getting-insights-from-sales-data-Qlikview-Sense/m-p/1104452#M463053 2016-08-01T15:59:38Z