Transforming month values in Fields

[#1]

Hello everyone,

I need to create a table which display the status green or red by month. Something like that:

My data base have a field called "Month" and another one called "Status Month" (that has the values Red or Green in text).

Anyone know how can i set the months as a field into the table, like in the example above?

It is possible to increase the table with the next months when the data base is populated? For example, today my data base doesn´t have data from december, but when this get updated, the table should display data from december in the right hand side column of the table.

Regards

[Anonymous]

Use a Pivot Table with Dimensions of KPI and Month, then drag the Month to the top.

When new Months are loaded into your qvw then they will appear in the Pivot Table.

[swuehl · Accepted solution]

Create a pivot table chart with dimensions KPI and Month and expression

=only([Status Month])

Drag the Month dimension to the top using the mouse.

If more month are added, they will appear automatically in the table.

Is this what you are looking for?

You can color the cells in a background color attribute expression:

=If( [Status Month] = 'Red', Lightred(), Lightgreen() )

[#4]

Thanks guys, i appreciate your help.

I tryed to color the cells in a background color as you suggested, but it shows the RGB code, as you can see below:

What is missing to display the color?

Thanks

[swuehl]

You need to use the color expression in the background color attribute expression, open the attributes by clicking on the small plus sign next to the expressions (on expression tab of chart properties).

[#6]

Thank you swuehl.

I am almost there! Now i ned to remove the text from the cell, and just display the color. See:

Thanks

[rwunderlich]

Make your expression be:

=' '

-Rob

[Anonymous]

Or put the same colour expression for text as background.

[MarcoWedel]

Hi,

maybe also helpful:

Hopefully quick question about calculated colours!

regards

Marco

[#10]

Thanks guys.