topic Re: Restricting the data in Bar chart in QlikView

Restricting the data in Bar chart

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

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 — Mon, 16 Oct 2017 08:20:25 GMT

This?

kvr9 — Mon, 16 Oct 2017 08:48:08 GMT

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 — Mon, 16 Oct 2017 09:05:26 GMT

Attached

kvr9 — Mon, 16 Oct 2017 10:10:30 GMT

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.