topic Re: How to color code an increase or a decrease of a metric over the previous period?(pivottable) in QlikView

How to color code an increase or a decrease of a metric over the previous period?(pivottable)

felipehenz — Sat, 16 Nov 2024 19:49:30 GMT

I am building a pivot table that has the total sales revenue per week. I would like to create a color flag so that the numbers of the current week will be colored green if there was an increase in sales from last week's, colored red if there was a decrease or black if the number remained the same. My expression is the sum of sales and dimension is date mm/dd/yyyy.

Re: How to color code an increase or a decrease of a metric over the previous period?(pivottable)

Arthur_Fong — Thu, 24 Oct 2019 05:17:16 GMT

There you go:

First, create a master calendar and create month and week column in it.

Then, sum up your value group by week and link this table to master calendar using week column as key.

Next, create a new column for Last Week value and join back to the original fact table.

Refer to qvw attached for reference.

Thanks and regards,

Arthur Fong

Re: How to color code an increase or a decrease of a metric over the previous period?(pivottable)

Brett_Bleess — Thu, 31 Oct 2019 20:37:07 GMT

Felipe, did Arthur's post and sample app get you what you needed? If so, please remember to come back to the thread and use the Accept as Solution button on Arthur's post to give him credit for the help and to let others know it worked for this use case. If you still need further help, leave an update.

Regards,
Brett

Re: How to color code an increase or a decrease of a metric over the previous period?(pivottable)

qliksus — Tue, 26 Nov 2019 02:57:29 GMT

You put the below expresssion in the color tab of the exresssion

if( Column(1) > Above(Column(1)) , Green() ,

if( Column(1) = Above(Column(1)) , Black() , red()))