Group dimesion. Aggregate problem

[#1]

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!

[#2]

Hi Ronald,

Can you send us a valid user/password ?

[#3]

Hi Eduardo,

How to remove section access?

Thanks

[#4]

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...

[#5]

Hi,

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

Thanks!

[#6]

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.

[#7]

Hi Jesper,

chapeau !

The most imortant secret is the setting of the background color

Reg

Roland

[#8]

Hi!

Maybe in this case you can use valuelist ?