Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jonathan Kirschen
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
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
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