topic Re: How can I reflect the second datamodel with respective selection of first datamodel in QlikView https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433479#M430880 <HTML><HEAD></HEAD><BODY><P>sample data but give any expression ...... so it easy to start from the base</P></BODY></HTML> Mon, 21 Aug 2017 06:08:49 GMT hemanthaanichet 2017-08-21T06:08:49Z How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433475#M430876 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have scenario like i have two data models. Both the data models are same but the table name &amp; column names are different. if i select the first data model year &amp; month for that year &amp; month my second data model has to reflect and has to display the values as per the selection </P><P></P><P>Note: Both data model could not be&nbsp; linked.</P><P></P><P>for example:</P><P>DataModel 1</P><P></P><P>Year , Month</P><P>Sum ({&lt;Year={$(=max(Year))}, Month=&gt;}Sales)</P><P></P><P>Datamodel 2</P><P></P><P style="font-size: 13.3333px;">Year1 , Month1</P><P style="font-size: 13.3333px;">Sum ({&lt;Year1={$(=max(Year1))}, Month1=&gt;}Sales1)</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Regards</P><P style="font-size: 13.3333px;">Hemanth</P></BODY></HTML> Mon, 21 Aug 2017 05:22:11 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433475#M430876 hemanthaanichet 2017-08-21T05:22:11Z Re: How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433476#M430877 <HTML><HEAD></HEAD><BODY><P>Way1: Use field event trigger to select other model field on one's selection</P><P>Way2: Refer other model field in the expression like:&nbsp; <SPAN style="color: #3d3d3d; font-size: 13.3333px; font-family: 'courier new', courier;">Sum ({&lt;Year1={$(=max(<SPAN style="color: #ff0000;">Year</SPAN>))}, Month1=&gt;}Sales1)</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13.3333px; font-family: 'courier new', courier;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13.3333px; font-family: 'courier new', courier;"><SPAN style="font-family: arial, helvetica, sans-serif;">Now, here you have to decide on which model field Year1/Year would be referred when.</SPAN><BR /></SPAN></P></BODY></HTML> Mon, 21 Aug 2017 05:45:00 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433476#M430877 tresB 2017-08-21T05:45:00Z Re: How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433477#M430878 <HTML><HEAD></HEAD><BODY><P>thanks Tresesco ..</P><P>way 2 is not working properly it refelects but the values are not matching.... </P><P></P><P>can pls say the way 1 with a example plsss...</P></BODY></HTML> Mon, 21 Aug 2017 05:48:14 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433477#M430878 hemanthaanichet 2017-08-21T05:48:14Z Re: How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433478#M430879 <HTML><HEAD></HEAD><BODY><P>Please share a sample to work upon.</P></BODY></HTML> Mon, 21 Aug 2017 05:50:03 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433478#M430879 tresB 2017-08-21T05:50:03Z Re: How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433479#M430880 <HTML><HEAD></HEAD><BODY><P>sample data but give any expression ...... so it easy to start from the base</P></BODY></HTML> Mon, 21 Aug 2017 06:08:49 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433479#M430880 hemanthaanichet 2017-08-21T06:08:49Z Re: How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433480#M430881 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173996_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 21 Aug 2017 06:32:28 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433480#M430881 tresB 2017-08-21T06:32:28Z Re: How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433481#M430882 <HTML><HEAD></HEAD><BODY><P>yeah this working but best way is event trigger if u dnt mine could pls do a sample for me pls.....</P></BODY></HTML> Mon, 21 Aug 2017 06:55:41 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433481#M430882 hemanthaanichet 2017-08-21T06:55:41Z Re: How can I reflect the second datamodel with respective selection of first datamodel https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433482#M430883 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Mon, 21 Aug 2017 07:14:28 GMT https://community.qlik.com/t5/QlikView/How-can-I-reflect-the-second-datamodel-with-respective-selection/m-p/1433482#M430883 tresB 2017-08-21T07:14:28Z