Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator 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
akpofureenughwu
Creator III
Creator III
Author

Here is the app

Thanks

its_anandrjs

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)

akpofureenughwu
Creator III
Creator III
Author

Please find the attached file ....

petter
Partner - Champion III
Partner - Champion III

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.

its_anandrjs

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


See attached.



sunny_talwar

May be this

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

With 2 dimensions

1) Location

2) Partner

akpofureenughwu
Creator III
Creator III
Author

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

sunny_talwar

See if the attach is what you want

akpofureenughwu
Creator III
Creator III
Author

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