topic Re: SALES ANALYSIS in QlikView https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247841#M624320 <HTML><HEAD></HEAD><BODY><P>Look at this</P></BODY></HTML> Mon, 12 Dec 2016 17:05:32 GMT Anonymous 2016-12-12T17:05:32Z SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247840#M624319 <HTML><HEAD></HEAD><BODY><P>Hi folks&nbsp;&nbsp; </P><P>&nbsp; Now i have a complicated job, simplifying i have make a report to show how much of one product sales, when the product "x" was in offer, for example...Atached have a sample..</P><P>What i want is filter a product and qlikview show me how much coupon have that product and after show me all product of that coupon...</P></BODY></HTML> Mon, 12 Dec 2016 16:45:12 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247840#M624319 Anonymous 2016-12-12T16:45:12Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247841#M624320 <HTML><HEAD></HEAD><BODY><P>Look at this</P></BODY></HTML> Mon, 12 Dec 2016 17:05:32 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247841#M624320 Anonymous 2016-12-12T17:05:32Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247842#M624321 <HTML><HEAD></HEAD><BODY><P>Try this in your list box?</P><P></P><P>= IF(Coupon = GetFieldSelections(Coupon), Product)</P></BODY></HTML> Mon, 12 Dec 2016 17:08:39 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247842#M624321 vishsaggi 2016-12-12T17:08:39Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247843#M624322 <HTML><HEAD></HEAD><BODY><P>Thank you by return, but not works...</P><P>Actually, my purpose is filter a only product and knows which product sales more.</P><P>I put beer in offer and consequently i sell that another product??</P></BODY></HTML> Mon, 12 Dec 2016 17:16:15 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247843#M624322 Anonymous 2016-12-12T17:16:15Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247844#M624323 <HTML><HEAD></HEAD><BODY><P>Try this:</P></BODY></HTML> Mon, 12 Dec 2016 17:33:40 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247844#M624323 Anonymous 2016-12-12T17:33:40Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247845#M624324 <HTML><HEAD></HEAD><BODY><P>Almost there...</P><P>Look the new attachment , its what i need...but i have a problem, my .qvd is big, and reload twice is very expensive...computationally...but works...</P><P></P><P></P><P>Maybe using Resident works too...but i want somethig more fast you know...=/ </P></BODY></HTML> Mon, 12 Dec 2016 17:52:17 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247845#M624324 Anonymous 2016-12-12T17:52:17Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247846#M624325 <HTML><HEAD></HEAD><BODY><P>So it is certainly less expensive, since the second reading is made of what is already in memory.</P></BODY></HTML> Mon, 12 Dec 2016 18:14:34 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247846#M624325 Anonymous 2016-12-12T18:14:34Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247847#M624326 <HTML><HEAD></HEAD><BODY><P>Yes, i think that is the only way...</P></BODY></HTML> Mon, 12 Dec 2016 18:17:04 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247847#M624326 Anonymous 2016-12-12T18:17:04Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247848#M624327 <HTML><HEAD></HEAD><BODY><P>Did you run the last attachment I sent?</P></BODY></HTML> Mon, 12 Dec 2016 18:26:23 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247848#M624327 Anonymous 2016-12-12T18:26:23Z Re: SALES ANALYSIS https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247849#M624328 <HTML><HEAD></HEAD><BODY><P>Yes, its works...Thank man....</P></BODY></HTML> Mon, 12 Dec 2016 18:34:55 GMT https://community.qlik.com/t5/QlikView/SALES-ANALYSIS/m-p/1247849#M624328 Anonymous 2016-12-12T18:34:55Z