topic Re: variable shift/ only selection should be visible in QlikView

variable shift/ only selection should be visible

akpofureenughwu — Tue, 29 Aug 2017 11:03:01 GMT

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

Re: variable shift/ only selection should be visible

akpofureenughwu — Tue, 29 Aug 2017 11:06:54 GMT

Here is the app

Thanks

Re: variable shift/ only selection should be visible

its_anandrjs — Tue, 29 Aug 2017 11:07:32 GMT

I did not found your attached but in the expression of the chart you can try to hard code this

Ex:-

Sum( {<Personname = {'barry '} >} Sales)

Re: variable shift/ only selection should be visible

akpofureenughwu — Tue, 29 Aug 2017 11:11:21 GMT

Please find the attached file ....

Re: variable shift/ only selection should be visible

petter — Tue, 29 Aug 2017 11:13:06 GMT

You can have one single expression which is:

=Sum ([PER NGN])

And then you add Partner as an additional dimension. Then you will get what you want.

See attached modified app.

Re: variable shift/ only selection should be visible

its_anandrjs — Tue, 29 Aug 2017 11:14:11 GMT

Is that you looking for by adding SET expression {<Partner = {'Barry'}>} .

See attached.

Re: variable shift/ only selection should be visible

sunny_talwar — Tue, 29 Aug 2017 11:17:12 GMT

May be this

=Sum ({$<Equity = {'55'}, Partner *= {'Barry'}>+<Equity = {'45'}, Partner *= {'Young'}>} [PER NGN])

With 2 dimensions

1) Location

2) Partner

Re: variable shift/ only selection should be visible

akpofureenughwu — Tue, 29 Aug 2017 11:29:01 GMT

Thank you Sunny..

May I didn't ask the question well,

my interest is on

Columns :Over/Under Cash Call (Young ) and Over/Under Cash Call (Barry )

Chart : cash call performance

Is it possible that if I use the partner filter, if I choose Young, Young's value appears and Barry value is removed ? (look at cash call figure chart)

Thanks

Re: variable shift/ only selection should be visible

sunny_talwar — Tue, 29 Aug 2017 11:36:10 GMT

See if the attach is what you want

Re: variable shift/ only selection should be visible

akpofureenughwu — Tue, 29 Aug 2017 11:44:13 GMT

We are making progress brother.

Can we do the same for the tables?

For columns : Columns :Over/Under Cash Call (Young ) and Over/Under Cash Call (Barry ) on the table.

Thanks

Re: variable shift/ only selection should be visible

sunny_talwar — Tue, 29 Aug 2017 11:47:01 GMT

Check the attached again

Re: variable shift/ only selection should be visible

akpofureenughwu — Tue, 29 Aug 2017 12:40:45 GMT

This is what I want....

But I have challenge..

How do I do this on qliksense?

Thanks petter-s its.anandrjs‌ stalwar1‌

Regards

Re: variable shift/ only selection should be visible

sunny_talwar — Tue, 29 Aug 2017 12:43:42 GMT

I would suggest to use Pivot table in Qlik Sense

Re: variable shift/ only selection should be visible

akpofureenughwu — Tue, 29 Aug 2017 12:48:41 GMT

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