topic Scripting/Presentation - Help in QlikView https://community.qlik.com/t5/QlikView/Scripting-Presentation-Help/m-p/880028#M307128 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>I need to plot a chart to display user over lap of different services they have choosen. Below the sample data along with expected result.</P><P></P><P>How can we calculate user over lap on the given data ? can we do something at script level or can it be done in chart using aggr fn.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" colspan="2" height="20" width="128">Source Data</TD><TD class="xl65" colspan="2" width="128">Expected result</TD></TR><TR><TD height="20">User ID</TD><TD>Service</TD><TD>Services</TD><TD>User Count</TD></TR><TR><TD align="right" height="20">1</TD><TD>S1</TD><TD>S1</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD>S2</TD><TD>S2</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD>S3</TD><TD>S3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>S1</TD><TD>S4</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">2</TD><TD>S2</TD><TD>S5</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">2</TD><TD>S4</TD><TD>S6</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">3</TD><TD>S2</TD><TD>S1-S2</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">4</TD><TD>S4</TD><TD>S1-S3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">5</TD><TD>S1</TD><TD>S1-S4</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">5</TD><TD>S4</TD><TD>S1-S5</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">6</TD><TD>S6</TD><TD>S1-S6</TD></TR><TR><TD align="right" height="20">7</TD><TD>S1</TD><TD>S1-S2-S3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">7</TD><TD>S4</TD><TD>S1-S2-S4</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">7</TD><TD>S6</TD><TD>S1-S2-S5</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">7</TD><TD>S2</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 15 Jul 2015 13:15:25 GMT manojkulkarni 2015-07-15T13:15:25Z Scripting/Presentation - Help https://community.qlik.com/t5/QlikView/Scripting-Presentation-Help/m-p/880028#M307128 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>I need to plot a chart to display user over lap of different services they have choosen. Below the sample data along with expected result.</P><P></P><P>How can we calculate user over lap on the given data ? can we do something at script level or can it be done in chart using aggr fn.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" colspan="2" height="20" width="128">Source Data</TD><TD class="xl65" colspan="2" width="128">Expected result</TD></TR><TR><TD height="20">User ID</TD><TD>Service</TD><TD>Services</TD><TD>User Count</TD></TR><TR><TD align="right" height="20">1</TD><TD>S1</TD><TD>S1</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD>S2</TD><TD>S2</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD>S3</TD><TD>S3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>S1</TD><TD>S4</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">2</TD><TD>S2</TD><TD>S5</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">2</TD><TD>S4</TD><TD>S6</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">3</TD><TD>S2</TD><TD>S1-S2</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">4</TD><TD>S4</TD><TD>S1-S3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">5</TD><TD>S1</TD><TD>S1-S4</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">5</TD><TD>S4</TD><TD>S1-S5</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">6</TD><TD>S6</TD><TD>S1-S6</TD></TR><TR><TD align="right" height="20">7</TD><TD>S1</TD><TD>S1-S2-S3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">7</TD><TD>S4</TD><TD>S1-S2-S4</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">7</TD><TD>S6</TD><TD>S1-S2-S5</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">7</TD><TD>S2</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 15 Jul 2015 13:15:25 GMT https://community.qlik.com/t5/QlikView/Scripting-Presentation-Help/m-p/880028#M307128 manojkulkarni 2015-07-15T13:15:25Z