topic Re: Cell Formatting Concerning Another Cell in the Same table? in QlikView

Cell Formatting Concerning Another Cell in the Same table?

Fri, 09 Aug 2013 14:16:54 GMT

Hi, is it possible to format a cell within a table where the formatting depends on the comparison of that cell with a cell in previous column.

In Excel this is possible, you just select the cell/column next to the cell you are formatting while making a formula or rule or macro. But I would like to apply this idea to QlikView and I am really hoping it is possible.

Thanks!

Re: Cell Formatting Concerning Another Cell in the Same table?

Anonymous — Fri, 09 Aug 2013 14:45:29 GMT

Yes, it is possible.

Take a look at the attribute expressions - they allow you to format text color, background color, text style, etc. Now, you can make the attribute expressions conditional, for example refer to another column, e.g.:

if(colimn(1)>0, red(), green())

Regards,

Michael