topic Re: grouping of Dimension groups in QlikView

grouping of Dimension groups

Wed, 25 Jun 2014 09:53:44 GMT

Hello all,

I would really appreciate your help with the following!

I want to create a Cyclic group of dimensions in a bar-chart. But I want to group and dimension with another group in this cyclic group.

For example:

I have 3 dimensions:

Weekday -> Monday/Tuesday/Wednesday/etc...

Weekpart -> midweek/weekend

Daypart -> Night/Day/Evening

I want to create a cyclic group with 2 options

1. Weekpart + Daypart
2. Weekpart

Is this possible? is it possible to add a group with the two dimensions in the cyclic group?

Re: grouping of Dimension groups

yduval75 — Wed, 25 Jun 2014 13:18:37 GMT

No, it's not possible.

But you can create a new field in the script Weekpart & ' - ' Daypart in the script and a cyclic group wih this new field and Weekpart

Re: grouping of Dimension groups

Wed, 25 Jun 2014 13:53:47 GMT

You mean in the SQL load script? But then you can't influence the two dimensions seperatly?

Re: grouping of Dimension groups

Wed, 25 Jun 2014 14:05:57 GMT

I did however manage to make a 2nd group with the Daypart dimension and a dimension with "= " this dimension counts everything so it's not really a pretty solution but it works.

Thanks for the help!

Re: grouping of Dimension groups

Wed, 25 Jun 2014 14:23:58 GMT

I see that there is also a possibility to create an if statement in an dimension. This way I can create an if statement like:

=if(GetCurrentField(GroupName)='Weekpart', Daypart)

This way the dimension Daypart will only be used if I select Weekpart in the group.