Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
julruiz123
Partner
Partner

Get value in a data island

Hello,

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".

How i can do it?

Thanks

model.png

1 Solution

Accepted Solutions
julruiz123
Partner
Partner
Author

Hi,

I solved my problem.

Just i added the field _PK_Historia_Paciente in each table () and i used this set analysis expression.

Count({1<_PK_Historia_Paciente_Facturacion = P({$} _PK_Historia_Paciente)>} [Total cargo])

model.png

View solution in original post

1 Reply
julruiz123
Partner
Partner
Author

Hi,

I solved my problem.

Just i added the field _PK_Historia_Paciente in each table () and i used this set analysis expression.

Count({1<_PK_Historia_Paciente_Facturacion = P({$} _PK_Historia_Paciente)>} [Total cargo])

model.png

View solution in original post