Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
mprsuper123
New Contributor

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

Re: Unchange the expression data when I select field on another table

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

Re: Unchange the expression data when I select field on another table

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

mprsuper123
New Contributor

Re: Unchange the expression data when I select field on another table

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

Re: Unchange the expression data when I select field on another table

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

mprsuper123
New Contributor

Re: Unchange the expression data when I select field on another table

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

Re: Unchange the expression data when I select field on another table

Can you upload a sample file?

Re: Unchange the expression data when I select field on another table

Hi

I think its give some idea to you,

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

Community Browser