variable shift/ only selection should be visible

[akpofureenughwu]

Hello everyone,

I have built an app to calculate the cash call of two partners Barry and Young on a particular location for a year ( I will be looking at more than one year later from 1999 -2003).

For year 1999.

I have managed to develop the app (see attached... dummy.qvw)

I 'm using a filter called partner.

On columns barry over/under cash call and young over/under cash call..  Is it possible that whenever I choose barry, only barry transaction that will be visible in both the chart and table?

See attached for clarity.

Regards

[sunny_talwar]

Check the attached again

[akpofureenughwu]

This is what I want....

But I have challenge..

How do I do this on qliksense?

Thanks petter-s its.anandrjs‌ stalwar1‌

Regards

[sunny_talwar]

I would suggest to use Pivot table in Qlik Sense

[akpofureenughwu]

How do I transpose this on qliksense..

In the qliksense app,

I can only see the calculation conditional  on  data handling but can only take one condition on like qlikview that can handle more than one condition.

Regards