topic Controlling two fields in different tables with one parameter. in QlikView https://community.qlik.com/t5/QlikView/Controlling-two-fields-in-different-tables-with-one-parameter/m-p/549271#M1143134 <HTML><HEAD></HEAD><BODY><P>Dear fellow users,</P><P></P><P>I'm quite new with Qlikview and slowly teaching myself how to work it. I've created a project from mostly our SQL db but I've run into some difficulties. Attached is a picture showing the setup. What I want to do is have a field that controls the two fields "InvoiceYearMonth" and "LossYearMonth" forcing them both to assume the value of this new field, lets call it "InvoiceLossTime". However I also want the two original fields to operate independently when this Invoice/Loss-field is inactive. I tried creating a new table with InvoiceYearMonth, LossYearMonth and this third field InvoiceLossTime which of course created a loop and a crash. I've searched numerous other discussions but I can't seem to figure this one out. I was hoping that it could be solved with a dummyvariable, something like IF(VariableX=1, InvoiceYearMonth=LossYearMonth) but I don't really know where to begin with that concept.</P><P></P><P>I appreaciate whatever help I can get and sorry if this is the 5000th repost of the same issue.</P><P></P><P>Regards,</P><P>J</P></BODY></HTML> Fri, 20 Sep 2013 14:45:54 GMT 2013-09-20T14:45:54Z Controlling two fields in different tables with one parameter. https://community.qlik.com/t5/QlikView/Controlling-two-fields-in-different-tables-with-one-parameter/m-p/549271#M1143134 <HTML><HEAD></HEAD><BODY><P>Dear fellow users,</P><P></P><P>I'm quite new with Qlikview and slowly teaching myself how to work it. I've created a project from mostly our SQL db but I've run into some difficulties. Attached is a picture showing the setup. What I want to do is have a field that controls the two fields "InvoiceYearMonth" and "LossYearMonth" forcing them both to assume the value of this new field, lets call it "InvoiceLossTime". However I also want the two original fields to operate independently when this Invoice/Loss-field is inactive. I tried creating a new table with InvoiceYearMonth, LossYearMonth and this third field InvoiceLossTime which of course created a loop and a crash. I've searched numerous other discussions but I can't seem to figure this one out. I was hoping that it could be solved with a dummyvariable, something like IF(VariableX=1, InvoiceYearMonth=LossYearMonth) but I don't really know where to begin with that concept.</P><P></P><P>I appreaciate whatever help I can get and sorry if this is the 5000th repost of the same issue.</P><P></P><P>Regards,</P><P>J</P></BODY></HTML> Fri, 20 Sep 2013 14:45:54 GMT https://community.qlik.com/t5/QlikView/Controlling-two-fields-in-different-tables-with-one-parameter/m-p/549271#M1143134 2013-09-20T14:45:54Z Re: Controlling two fields in different tables with one parameter. https://community.qlik.com/t5/QlikView/Controlling-two-fields-in-different-tables-with-one-parameter/m-p/549272#M1143135 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The way I would do this is to use a data island and triggers.</P><P></P><P>1. Create a new table "InvoiceLossTime" that is not connected to the rest of the data model</P><P>2. Go to Settings -&gt; Document Properties.&nbsp; Select the "Triggers" Tab</P><P>3. Select the appropriate field in the InvoiceLossTime table (in this example I will assume you picked InvoiceLossYear)</P><P>4. Click the "Add Action(s)..." button below "OnSelect</P><P>5. Add two actions.&nbsp; Once that set the InvoiceYear = InvoiceLostYear and another action that set the LossYear = InvoiceLostYear.</P><P>6. Repeat as needed for other fields (YearMonth, Month, etc.)</P></BODY></HTML> Fri, 20 Sep 2013 17:59:22 GMT https://community.qlik.com/t5/QlikView/Controlling-two-fields-in-different-tables-with-one-parameter/m-p/549272#M1143135 Josh_Good 2013-09-20T17:59:22Z