topic Linked Cyclic Groups in QlikView https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174146#M43085 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>My first post, so hopefully in the right forum.</P><P>I am trying to find out how to link two cyclic groups.</P><P>An example will probably help: I have a straight table which has cost and revenue columns which are cycled through Actual and Budget. Here's the problem...it is currently possible to select Actual Revenue and Budget Cost, which I want to avoid in this case. Ideally when Actual is selected in Cost then Actual is also selected in Revenue.</P><P>Any suggestions will be gratefully received.</P><P>Thanks</P><P>Simon</P><P></P><P></P><P></P><P></P></BODY></HTML> Thu, 03 Dec 2009 18:26:20 GMT 2009-12-03T18:26:20Z Linked Cyclic Groups https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174146#M43085 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>My first post, so hopefully in the right forum.</P><P>I am trying to find out how to link two cyclic groups.</P><P>An example will probably help: I have a straight table which has cost and revenue columns which are cycled through Actual and Budget. Here's the problem...it is currently possible to select Actual Revenue and Budget Cost, which I want to avoid in this case. Ideally when Actual is selected in Cost then Actual is also selected in Revenue.</P><P>Any suggestions will be gratefully received.</P><P>Thanks</P><P>Simon</P><P></P><P></P><P></P><P></P></BODY></HTML> Thu, 03 Dec 2009 18:26:20 GMT https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174146#M43085 2009-12-03T18:26:20Z Linked Cyclic Groups https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174147#M43086 <HTML><HEAD></HEAD><BODY><P>Actual and Revenue are separate tables? In what way are these linked?</P></BODY></HTML> Thu, 03 Dec 2009 18:54:37 GMT https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174147#M43086 Anonymous 2009-12-03T18:54:37Z Linked Cyclic Groups https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174148#M43087 <HTML><HEAD></HEAD><BODY><P>They're in different tables and linked by the model set ID... i.e. a model for actual and a model for budget.</P></BODY></HTML> Thu, 03 Dec 2009 19:15:25 GMT https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174148#M43087 2009-12-03T19:15:25Z Linked Cyclic Groups https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174149#M43088 <HTML><HEAD></HEAD><BODY><P>Actual Revenue and Budget Cost can seperately be choosen . . .</P><P>If the Actual Revenue should be selected in both tables maybe you should consider combining the two tables to one table?</P><P>Could you give a sample of the loaded tables as you have them now? Maybe I can show you what I mean with your tables.</P></BODY></HTML> Thu, 03 Dec 2009 19:24:04 GMT https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174149#M43088 Anonymous 2009-12-03T19:24:04Z Linked Cyclic Groups https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174150#M43089 <HTML><HEAD></HEAD><BODY><P>Just wanted to say thanks for engaging...I have solved this using a pivot report.</P></BODY></HTML> Wed, 09 Dec 2009 18:59:35 GMT https://community.qlik.com/t5/QlikView/Linked-Cyclic-Groups/m-p/174150#M43089 2009-12-09T18:59:35Z