Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (4)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Get value in a data island

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
Highlighted
Partner
Partner

Get value in a data island

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