topic Re: Complicated Scenario for Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Complicated-Scenario-for-Set-Analysis/m-p/746070#M266305 <HTML><HEAD></HEAD><BODY><P>Please post an example document that demonstrates the problem.</P></BODY></HTML> Fri, 14 Nov 2014 10:10:23 GMT Gysbert_Wassenaar 2014-11-14T10:10:23Z Complicated Scenario for Set Analysis https://community.qlik.com/t5/QlikView/Complicated-Scenario-for-Set-Analysis/m-p/746069#M266304 <HTML><HEAD></HEAD><BODY><P>I have the following data</P><P><IMG alt="sample.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/71248_sample.jpg" /></P><P>Supposed that one card can only pay for one transaction,I want to identify the sale representatives that violating this rules and plot a bar chart for the involved sale rep. The dimension of the bar chart will be Sales_Rep and expression will be count In such scenario, sales_1, sales_4 and sales_5 be should be identified as card_0001 and card_0002 is paying for one transaction.</P><P>The count for the sale reps will be as follow</P><P>1. Sales_1&nbsp; 3</P><P>2. Sales_4&nbsp; 1</P><P>3. Sales_5&nbsp; 2</P><P></P><P>Can i use set analysis to achieve this? This is because I want to set the card limit to be a dynamic one. e.g, the maximum number of transaction paid by one can can be set to 2 by users.</P></BODY></HTML> Fri, 14 Nov 2014 07:45:04 GMT https://community.qlik.com/t5/QlikView/Complicated-Scenario-for-Set-Analysis/m-p/746069#M266304 2014-11-14T07:45:04Z Re: Complicated Scenario for Set Analysis https://community.qlik.com/t5/QlikView/Complicated-Scenario-for-Set-Analysis/m-p/746070#M266305 <HTML><HEAD></HEAD><BODY><P>Please post an example document that demonstrates the problem.</P></BODY></HTML> Fri, 14 Nov 2014 10:10:23 GMT https://community.qlik.com/t5/QlikView/Complicated-Scenario-for-Set-Analysis/m-p/746070#M266305 Gysbert_Wassenaar 2014-11-14T10:10:23Z