Discussion Board for collaboration related to Creating Analytics for QlikView.
I'm trying to use two different dimensions as alternate filters for the same bubble chart.
e.g. 1st scenario : "Type" filter selected which has categories like Type 1, Type 2 and Type 3
The chart shows segregation of data by "Type" and shows Type 1, Type 2 and Type 3 in the legend.
2nd scenario: " Status" Filter selected which has categories like "New", "In Progress" and " Close"
The same chart would show the segregation of data by "Status" and should show New, In Progress and Close in the legend.
Do you trying something like this?
LOAD * INLINE [
Type, Status, Value
Type3, In Progress,60
Type5, In Progress,30
I have used a Grid chart, 1. Dimensions: status, Type. 2.Expression =Value
Other properties are default.
Have a look at Cyclic Groups.
You can access this from the Edit Groups button on the Chart Dimensions sheet.
There is a video on Cyclic & Drill Down Groups here Creating Cycle and Drill Groups