Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
akpofureenughwu
Contributor III

variable shift/ only selection should be visible

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

13 Replies
Highlighted
akpofureenughwu
Contributor III

Re: variable shift/ only selection should be visible

Here is the app

Thanks

Highlighted

Re: variable shift/ only selection should be visible

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)

Highlighted
akpofureenughwu
Contributor III

Re: variable shift/ only selection should be visible

Please find the attached file ....

Highlighted
MVP
MVP

Re: variable shift/ only selection should be visible

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.

Highlighted

Re: variable shift/ only selection should be visible

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


See attached.



Highlighted

Re: variable shift/ only selection should be visible

May be this

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

With 2 dimensions

1) Location

2) Partner

Highlighted
akpofureenughwu
Contributor III

Re: variable shift/ only selection should be visible

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

Highlighted

Re: variable shift/ only selection should be visible

See if the attach is what you want

Highlighted
akpofureenughwu
Contributor III

Re: variable shift/ only selection should be visible

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