topic Get value in a data island in QlikView https://community.qlik.com/t5/QlikView/Get-value-in-a-data-island/m-p/256859#M1182663 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I was wondering how i can resolve the next situation. When the date it's selected returns for example all the "Ocupacion" and "Facturacion" asociated with the date filter. But i need a chart with the "Facturacion" where "Historia ocupación, Ingreso ocupación" is equal to "Historia factura, Ingreso factura" independent of the date in "Facturacion". </P><P></P><P></P><P>How i can do it?</P><P></P><P></P><P>Thanks</P><P></P><P></P><P><IMG alt="model.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/8877_model.png" width="450" /></P></BODY></HTML> Fri, 25 Nov 2011 14:54:11 GMT julruiz123 2011-11-25T14:54:11Z Get value in a data island https://community.qlik.com/t5/QlikView/Get-value-in-a-data-island/m-p/256859#M1182663 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I was wondering how i can resolve the next situation. When the date it's selected returns for example all the "Ocupacion" and "Facturacion" asociated with the date filter. But i need a chart with the "Facturacion" where "Historia ocupación, Ingreso ocupación" is equal to "Historia factura, Ingreso factura" independent of the date in "Facturacion". </P><P></P><P></P><P>How i can do it?</P><P></P><P></P><P>Thanks</P><P></P><P></P><P><IMG alt="model.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/8877_model.png" width="450" /></P></BODY></HTML> Fri, 25 Nov 2011 14:54:11 GMT https://community.qlik.com/t5/QlikView/Get-value-in-a-data-island/m-p/256859#M1182663 julruiz123 2011-11-25T14:54:11Z Get value in a data island https://community.qlik.com/t5/QlikView/Get-value-in-a-data-island/m-p/256860#M1182664 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I solved my problem. </P><P></P><P>Just i added the field _PK_Historia_Paciente in each table () and i used this set analysis expression.</P><P></P><P>Count({1&lt;_PK_Historia_Paciente_Facturacion = P({$} _PK_Historia_Paciente)&gt;} [Total cargo])</P><P></P><P><IMG alt="model.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/8885_model.png" width="450" /></P></BODY></HTML> Fri, 25 Nov 2011 21:05:06 GMT https://community.qlik.com/t5/QlikView/Get-value-in-a-data-island/m-p/256860#M1182664 julruiz123 2011-11-25T21:05:06Z