Showing partial data on Bar Charts

sagar_vij99 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Showing partial data on Bar Charts

kaushiknsolanki — Fri, 14 Jul 2017 10:34:23 GMT

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

topic Re: Showing partial data on Bar Charts in QlikView

Showing partial data on Bar Charts

Re: Showing partial data on Bar Charts