topic Re: Export to excel table if background colors in QlikView

Export to excel table if background colors

Fri, 31 May 2013 14:43:35 GMT

Good day guys,

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

Re: Export to excel table if background colors

marcus_sommer — Mon, 03 Jun 2013 12:03:52 GMT

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

Re: Export to excel table if background colors

Mon, 03 Jun 2013 12:58:26 GMT

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

marcus_sommer — Tue, 04 Jun 2013 06:50:08 GMT

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

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

- Marcus