topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/789970#M279339 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>I want to get the count based on the premium value. If I am having a table like below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"><TBODY><TR style="height: 15pt;"><TD class="xl63" height="20" style="background-color: #f2f2f2; width: 48pt; height: 15pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">Policy</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #f2f2f2; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">Premium</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P1</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">100</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P5</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">100</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P2</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">200</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P8</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">200</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P9</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">200</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P3</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">300</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P7</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">300</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P4</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">400</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P10</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">400</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P6</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">500</SPAN></TD></TR></TBODY></TABLE><P></P><P>Tried the below in set analysis did not work. Please advise.</P><P>if<SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Premium Band]</SPAN><SPAN style="color: #000000; font-size: 8pt;">='0 - 200',</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="color: #000000; font-size: 8pt;">({$&lt; P</SPAN><SPAN style="color: #800000; font-size: 8pt;">remium</SPAN><SPAN style="color: #000000; font-size: 8pt;">= {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=0 &lt;200"</SPAN><SPAN style="color: #000000; font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="color: #000000; font-size: 8pt;"> Policy</SPAN><SPAN style="color: #000000; font-size: 8pt;">)) </SPAN></P><P></P><P>The <SPAN style="color: #800000; font-size: 8pt;">Premium Band is the field created speratly.</SPAN></P><P></P><P></P><P>Thanks,</P><P>Sijo</P></BODY></HTML> Wed, 14 Jan 2015 15:42:21 GMT 2015-01-14T15:42:21Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/789970#M279339 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>I want to get the count based on the premium value. If I am having a table like below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"><TBODY><TR style="height: 15pt;"><TD class="xl63" height="20" style="background-color: #f2f2f2; width: 48pt; height: 15pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">Policy</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #f2f2f2; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">Premium</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P1</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">100</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P5</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">100</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P2</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">200</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P8</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">200</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P9</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">200</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P3</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">300</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P7</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">300</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P4</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">400</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P10</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">400</SPAN></TD></TR><TR style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 15pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">P6</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">500</SPAN></TD></TR></TBODY></TABLE><P></P><P>Tried the below in set analysis did not work. Please advise.</P><P>if<SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Premium Band]</SPAN><SPAN style="color: #000000; font-size: 8pt;">='0 - 200',</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="color: #000000; font-size: 8pt;">({$&lt; P</SPAN><SPAN style="color: #800000; font-size: 8pt;">remium</SPAN><SPAN style="color: #000000; font-size: 8pt;">= {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=0 &lt;200"</SPAN><SPAN style="color: #000000; font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="color: #000000; font-size: 8pt;"> Policy</SPAN><SPAN style="color: #000000; font-size: 8pt;">)) </SPAN></P><P></P><P>The <SPAN style="color: #800000; font-size: 8pt;">Premium Band is the field created speratly.</SPAN></P><P></P><P></P><P>Thanks,</P><P>Sijo</P></BODY></HTML> Wed, 14 Jan 2015 15:42:21 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/789970#M279339 2015-01-14T15:42:21Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/789971#M279340 <HTML><HEAD></HEAD><BODY><P>Hi Sijo,</P><P></P><P>try adding your [Premium Band] condition to your set.</P><P></P><P>Count({$&lt;[Premium Band]={'0 - 200'}, Premium={"&gt;=0&lt;200"}&gt;} DISTINCT Policy)</P><P></P><P>Marcus</P></BODY></HTML> Wed, 14 Jan 2015 15:44:55 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/789971#M279340 marcus_malinow 2015-01-14T15:44:55Z