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

Unchange the expression data when I select field on another table

Anonymous — Thu, 18 Oct 2012 16:19:50 GMT

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.

One More requiremnt:

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,

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

Thu, 18 Oct 2012 16:24:24 GMT

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

MayilVahanan — Thu, 18 Oct 2012 16:24:43 GMT

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

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

Anonymous — Fri, 19 Oct 2012 13:18:22 GMT

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,

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

MayilVahanan — Fri, 19 Oct 2012 16:19:16 GMT

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

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

Anonymous — Fri, 19 Oct 2012 16:52:50 GMT

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

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

CELAMBARASAN — Fri, 19 Oct 2012 17:02:47 GMT

Can you upload a sample file?

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

MayilVahanan — Fri, 19 Oct 2012 17:17:14 GMT

I think its give some idea to you,

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