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: 
Anonymous
Not applicable

Unchange the expression data when I select field on another table

Hello,

I have two charts on one sheet,

if I selection one of Project Manager, and without change the Percentage on the other table (Staffing Projection Table).

How I express this ?

thanks for your help.2012-10-18_1213.png

One More requiremnt:

2012-10-19_0915.png

Hello,

I try to select one of Project Manager (CHEN, V) , I want to show the total 108 % for this employee, not just 13%.

Is it possible ?

Thanks,

H

7 Replies
Not applicable
Author

If you don't want the above chart to respond to selection in Project Manager field, use set analysis in the above chart's expr.

Post ur charts' expr here, so that i can modify it and repost.

regards

MayilVahanan

Hi

I think you want to exclude the selection in that particular chart? am i correct? if so,

use any of the following

1.Alternate state for that chart.

2.Detached that chart

3.Sum({1}Sales) in expression

These option exclude the selections

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

Hello,

I try to select one of Project Manager (CHEN, V) , I want to show the total 108 % for this employee, not just 13%.

Is it possible ?

Thanks,

H

2012-10-19_0915.png

MayilVahanan

HI

Try like this

If you use sum(total Amount) always gives  the total amount of all..

=sum(total<ProjectManager> Amount) gives based on project manager  amount

=Sum(total<EmployeeName>Amount) gives based on employeename amount,

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

Hello,

I use your suggestion

=Sum(total<EmployeeName>Amount) gives based on employeename amount,

Then, I got 108% for each Project Manger.  But I pick (CHEN, V) PM then I still got 13%.

Thanks,

Henness

2012-10-19_1250.png

CELAMBARASAN
Partner - Champion
Partner - Champion

Can you upload a sample file?

MayilVahanan

Hi

I think its give some idea to you,

=if(GetFieldSelections(ProjectManager) > 1,Sum({1}TOTAL Amount),  Sum(total<EmployeeName>Amount))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.