topic Re: Use two different dimensions as alternate filters for the same chart ? in QlikView

Use two different dimensions as alternate filters for the same chart ?

Wed, 01 Jun 2016 02:29:54 GMT

Hi,

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.

Please advise.

prabir_c — Wed, 01 Jun 2016 09:36:26 GMT

Hello,

Do you trying something like this?

In script...

LOAD * INLINE [

Type, Status, Value

Type1, New,40

Type2, Close,50

Type3, In Progress,60

Type4, Close,20

Type5, In Progress,30

Type6, New,100

];

I have used a Grid chart, 1. Dimensions: status, Type. 2.Expression =Value

Other properties are default.

Colin-Albert — Wed, 01 Jun 2016 09:41:51 GMT

Have a look at Cyclic Groups.

You can access this from the Edit Groups button on the Chart Dimensions sheet.

Colin-Albert — Wed, 01 Jun 2016 09:45:17 GMT

There is a video on Cyclic & Drill Down Groups here Creating Cycle and Drill Groups