Restricting the data in Bar chart

[kvr9]

Hi Team,

I have an issue with restricting the data in chart.

Below is the format of my data.

Load *Inline

Country,

Company,

Emp_Type,

Sales,

Benchmark

from table sales.xls;

I tried to build a sales chart for companies along with country  benchmark which is taken as a line.

The Emp_type data contain two types of employees(E1 , E2) .so I want to represent only one emp type on my chart.

The other emp type has to be changed based on the filter .

Could someone help how to build a chart by filtering the Emp_type data level.

Attached is sample data and qvw.

[Anil_Babu_Samineni]

This?

[kvr9]

Hi Anil,

I want to see  Emp_type E1 as default on my chart,up on changing the filter I would like to see E2.

But current situation is populating both the types together.

[Anil_Babu_Samineni]

Attached

[kvr9 · Accepted solution]

Hi Anil,

I can see the data is filtered to E1 only,but If no filters are applied then by default I would like to see E1 data,

Current situation if I clear all the filters then I'm seeing combined data which is wrong.

My requirement is as below

1.If no filters are applied on dashboard then  I would like to see E1 type data as default on my graph.

2.When I apply filter on Emp type then It should change respectively.

3.I don't want any combine data if filters are cleared.

Hope my requirement is clear now.