topic Re: Transforming month values in Fields in QlikView

Transforming month values in Fields

Fri, 06 Nov 2015 19:14:02 GMT

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

Re: Transforming month values in Fields

Anonymous — Fri, 06 Nov 2015 19:17:46 GMT

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.

Re: Transforming month values in Fields

swuehl — Fri, 06 Nov 2015 19:18:12 GMT

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() )

Re: Transforming month values in Fields

Fri, 06 Nov 2015 21:49:41 GMT

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

Re: Transforming month values in Fields

swuehl — Fri, 06 Nov 2015 21:53:59 GMT

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

Re: Transforming month values in Fields

Fri, 06 Nov 2015 22:28:51 GMT

Thank you swuehl.

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

Thanks

Re: Transforming month values in Fields

rwunderlich — Fri, 06 Nov 2015 22:36:55 GMT

Make your expression be:

=' '

-Rob

Re: Transforming month values in Fields

Anonymous — Fri, 06 Nov 2015 22:48:37 GMT

Or put the same colour expression for text as background.

Re: Transforming month values in Fields

MarcoWedel — Fri, 06 Nov 2015 23:19:28 GMT

Hi,

maybe also helpful:

Hopefully quick question about calculated colours!

regards

Marco

Re: Transforming month values in Fields

Mon, 09 Nov 2015 11:12:18 GMT

Thanks guys.