Showing partial data on Bar Charts

[sagar_vij99]

Hi All,

Please see the below example and provide your valueable suggestions :

I have two tables : Prod and Indi

Prod:

Name,Vol,QcD,Err,SubTeam

Ankit,100,10,2,Construction

Ankit,80,5,2,Genius

Indi:

Name,SubTeam

Ankit,Construction

Now when i make chart taking SubTeam as dimension with sum(Vol) and sum(Err) as expressions. I get numbers for both subteams but I want to display only that subteam 'which is not equal' to the subteam of Indi table. This means i will have graph for only Genius Subteam.

Is it possible or the chart will show bars for both subteams.

Please help me out here..

Regards

Sagar

[kaushiknsolanki]

Dear Sagar,

For this you will have to create a flag in script like below.

Indi:

Load Name&SubTeam as Key

From Indi;

Prod:

Load Name,Vol,QcD,Err,SubTeam,if(Exists(Key,Name&SubTeam),1,0) as Flag

From pqr;

Now in chart you should use below expression.

Sum({<Flag = {"1"}>}Vol)

Sum({<Flag = {"1"}>}Err)

Regards,

Kaushik Solanki