https://community.qlik.com/t5/QlikView/Field-Values-True-False-in-cyclic-group/m-p/240598#M91112 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P>I have a true/false field that I would like to incorporate in a cyclic group. This way the it shows all the true fields and when pressing the cyclic group it will show the false fields.</P><P>Should I be using an expression in the cyclic group to achieve this? I hope someone is able to provide me with some pointers.</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 13 Nov 2009 22:00:11 GMT 2009-11-13T22:00:11Z https://community.qlik.com/t5/QlikView/Field-Values-True-False-in-cyclic-group/m-p/240598#M91112 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P>I have a true/false field that I would like to incorporate in a cyclic group. This way the it shows all the true fields and when pressing the cyclic group it will show the false fields.</P><P>Should I be using an expression in the cyclic group to achieve this? I hope someone is able to provide me with some pointers.</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 13 Nov 2009 22:00:11 GMT https://community.qlik.com/t5/QlikView/Field-Values-True-False-in-cyclic-group/m-p/240598#M91112 2009-11-13T22:00:11Z https://community.qlik.com/t5/QlikView/Field-Values-True-False-in-cyclic-group/m-p/240599#M91113 <HTML><HEAD></HEAD><BODY><P>Create a cyclic group with two calculated dimensions</P><P>first one such as IF(MyField=-1,'TRUE')</P><P>Second one such as IF(MYFIELD&lt;&gt;-1,'TRUE')</P><P>Then click the Remove null values in the chart dimensions sheet for the group.</P><P>Rgds,</P><P>Sébastien</P></BODY></HTML> Fri, 13 Nov 2009 22:04:39 GMT https://community.qlik.com/t5/QlikView/Field-Values-True-False-in-cyclic-group/m-p/240599#M91113 2009-11-13T22:04:39Z