topic Re: Aggregation in Dimension in QlikView

Aggregation in Dimension

Wed, 23 Oct 2013 11:42:01 GMT

I have an CASE_ID which identifies a specific case and some steps, which are made within this case.

STEP:

CASE_ID, FLAG A, STEP_ID

123, A,1

123, B,1

123, A,2

123, C,1

456, A,1

456, A,2

456, B,1

456, A,4

I have one Dimension Field "D1". In Skript I do like:

STEP:

LOAD

CASE_ID,

if(FLAG='A', "Group1") AS D1

From STEP;

concatenate(STEP)

LOAD

CASE_ID,

if(FLAG='B', "Group2") AS D1

From STEP;

Now i want to display a Bar-Chart with D1 as Dimension and "distinct count(CASE_ID)" as expression.

When somebody selects one Bar of the Chart, I want the CASE_ID to be selected.

So i did "aggr(D1, CASE_ID)" as dimension.

It seems that if a CASE_ID belongs to more than one flag, it will be thrown out and not included in calculation.

Can someone tell me if it is the right way to handle this?

Thanks

Re: Aggregation in Dimension

yduval75 — Wed, 23 Oct 2013 11:58:12 GMT

Hello,

You can use a hierarchic group to make a drill down from the group "D1" to the CASE_ID

i think this .qvw will help you.

Best Regards,

Yoann

Re: Aggregation in Dimension

Wed, 23 Oct 2013 12:05:27 GMT

Thank you.

But what I want is to get only the CASE_IDs selected which are within one group, by selection a unique bar. I do not want to get the STEPs selected. The Step Table is only to "mark" a CASE_ID and bind it to a group.