topic Group dimesion. Aggregate problem in QlikView

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 10:46:05 GMT

Hi Community,

Here's the sample bar chart. This chart have 3 dimensions ( Date, Response, Role) and 1 expression: count(Response)

This chart yield correct response count. But I want to display this bars with a single color. Or more likely I don't want to display the Roles in the dimension.

Any idea? I'm looking at aggregation function to solve this.

Thanks!

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 10:56:23 GMT

Hi,

Cant you just delete Roles from the dimensions?

Br /Daniel

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 11:02:32 GMT

Hi daniel,

Thanks for the response but I need the Role Dimension (since some user have 2 or more roles).

I'm thinking if I can use aggregation on this? group response according to roles?

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 11:07:21 GMT

Hi Ronald,

you are here ?

The question from Daniel is not so bad. Or do I understand your problem not quite clear? If its only a design problem, take a look at the colors tab and use the same color. Thats to easy, isn*t it ?

Regards

Roland

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 11:15:28 GMT

Hi Roland and Daniel,

Here's another image I want to achieve. This chart has two dimension (date and response)

Notice the inconsistent count for each bar. This inconsistent count caused by user with multiple roles. So I put the role in the dimension and got the numbers I want. unfortunately with different presentation. If only I can group the response per role. (Honestly i can't fully understand aggregate function )

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 11:31:26 GMT

try:

=aggr ( count ( Response ) , Role )

Set the expression color to a fixed color, that might work also.

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 12:45:48 GMT

Hi Jesper,

I've tried your suggestion but still not what I want to achieve.

Anyone?

Thanks

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 12:55:17 GMT

Hi,

do you can post your qvw document?

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 13:15:26 GMT

Hi All,

Please see attached file.

Thanks in advance!

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 13:20:55 GMT

Hi,

remove the section access. I don't can access the document.

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 13:26:07 GMT

Hi Ronald,

Can you send us a valid user/password ?

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 13:41:32 GMT

Hi Eduardo,

How to remove section access?

Thanks

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 13:46:27 GMT

delete in your script

Section Access;

.....

Section Application;

If you not use Section Access in your script, verify in Document Propertie / Tab Opening / the parameter "Initial Data Reduction Based on Section Access" are unchecked

Reload your QVW and save...

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 14:44:20 GMT

Hi,

I can't remove the user access so I create a new one.

Thanks!

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 14:51:07 GMT

Solution:

1: Un-check the box 'Text on data point' - but keep the box 'Numbers on data point' checked

2: Set the expression color to for exapmle red() (expression background color)

3: Set the style to the upper-left template on the STYLE-pane, LOOK-section.

EDIT: 4: remove the legend

Result attached.

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 15:14:19 GMT

Hi Jesper,

chapeau !

The most imortant secret is the setting of the background color

Reg

Roland

Group dimesion. Aggregate problem

Wed, 20 Oct 2010 15:22:03 GMT

Hi!

Maybe in this case you can use valuelist ?