Discussion board where members can get started with QlikView.
I have an issue with restricting the data in chart.
Below is the format of my data.
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.
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.
View solution in original post
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.