topic Re: Cyclic Group with condition in QlikView https://community.qlik.com/t5/QlikView/Cyclic-Group-with-condition/m-p/769790#M273301 <HTML><HEAD></HEAD><BODY><P>Any help from anyone...Its some what urgent.</P><P></P><P>More Thanks,</P><P>Ajay</P></BODY></HTML> Mon, 23 Feb 2015 10:46:07 GMT ajaykumar1 2015-02-23T10:46:07Z Cyclic Group with condition https://community.qlik.com/t5/QlikView/Cyclic-Group-with-condition/m-p/769789#M273300 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P><SPAN style="font-size: 13.3333330154419px;">Need to create one cyclic group name as '<STRONG>Cyg_N'</STRONG> with the fields <STRONG>Name,No and No_Id</STRONG></SPAN> with condition.The below are my output data.</P><P></P><P style="font-size: 13.3333330154419px;">Am failing to create the below condition and how to show that in cyclic group level.</P><P></P><P style="font-size: 13.3333330154419px;">If I am selecting the <STRONG>‘No_Id’</STRONG> field then</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; font-size: 13.3333330154419px;"><TBODY><TR><TD style="border: 1pt solid windowtext; padding: 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">No_Id</P></TD><TD style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">Exp1</P></TD><TD style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">Exp2</P></TD><TD style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">Exp3</P></TD><TD style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">Exp4</P></TD><TD style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">Exp5</P></TD><TD style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">Exp6</P></TD><TD style="border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: solid solid solid none; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">Exp7</P></TD></TR><TR><TD style="border-right-color: windowtext; border-bottom-color: windowtext; border-left-color: windowtext; padding: 0 5.4pt; border-style: none solid solid; border-right-width: 1pt; border-bottom-width: 1pt; border-left-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">ABC</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">2155</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">-2155</P></TD></TR><TR><TD style="border-right-color: windowtext; border-bottom-color: windowtext; border-left-color: windowtext; padding: 0 5.4pt; border-style: none solid solid; border-right-width: 1pt; border-bottom-width: 1pt; border-left-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">ABC</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">2180</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">2180</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">0</P></TD><TD style="border-right-color: windowtext; border-bottom-color: windowtext; padding: 0 5.4pt; border-style: none solid solid none; border-right-width: 1pt; border-bottom-width: 1pt;" valign="top" width="80"><P style="margin-bottom: 0.0001pt;">2180</P></TD></TR></TBODY></TABLE><P></P><P style="font-size: 13.3333330154419px;">Here When I have to make filter on&nbsp; the ‘<STRONG>INLN’</STRONG> the condition is <STRONG>‘INLN</STRONG>’=0</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px;">For the below 2 are ok.</SPAN></P><P></P><P></P><P>If I am selecting the ‘<STRONG>Name’</STRONG> field then</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Name</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp1</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp2</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp3</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp4</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp5</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp6</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp7</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">ABC</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">2180</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">0</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">2180</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">60</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">2196</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">0</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">44</P></TD></TR></TBODY></TABLE><P></P><P>If I am selecting the <STRONG>‘No’</STRONG> field then</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">No</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp1</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp2</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp3</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp4</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp5</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp6</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">Exp7</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">ABC</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">2180</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">0</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">2180</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">60</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">2196</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">0</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="80"><P style="margin-bottom: .0001pt;">44</P></TD></TR></TBODY></TABLE><P></P><P>Here am attaching my sample data.I hope yous understand my requirement</P></BODY></HTML> Mon, 23 Feb 2015 10:16:15 GMT https://community.qlik.com/t5/QlikView/Cyclic-Group-with-condition/m-p/769789#M273300 ajaykumar1 2015-02-23T10:16:15Z Re: Cyclic Group with condition https://community.qlik.com/t5/QlikView/Cyclic-Group-with-condition/m-p/769790#M273301 <HTML><HEAD></HEAD><BODY><P>Any help from anyone...Its some what urgent.</P><P></P><P>More Thanks,</P><P>Ajay</P></BODY></HTML> Mon, 23 Feb 2015 10:46:07 GMT https://community.qlik.com/t5/QlikView/Cyclic-Group-with-condition/m-p/769790#M273301 ajaykumar1 2015-02-23T10:46:07Z