Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Export to excel table if background colors

Good day guys,
Cores na Evolução.png
I am needing to create a macro that when the worksheet is exported to excel, cells with values ​​greater than when the previous record is painted in red and when at or below the previous record is in green.

Await some help thanks.

Jonathan Kirschen

3 Replies

Re: Export to excel table if background colors

Value depended background colors could set in qlikview and could also exported in excel - see chart properties in tab visualization or by attribut formulas.

- Marcus

Not applicable

Re: Export to excel table if background colors

Marcus

I need to create a rule that he will check the previous record and coloring them according to whether the value has increased or decreased, and after that export this table and send via email, the routine to export via email already own just that I'm not getting coloring the cell.

graciously

Re: Export to excel table if background colors

I would try to solve this in QV with a attribut formula to set the coloring. It is an built-in feature. Solutions with macros are more complicated.

= if(Before(sum(YOURVALUE)) < sum(YOURVALUE), green(),

     if(Before(sum(YOURVALUE)) > sum(YOURVALUE), red(), Yellow()))

BackgroundColor.jpg

I think you can it adjust/extend to your needs.

- Marcus

Community Browser