Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cell Formatting Concerning Another Cell in the Same table?

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!

Labels (1)
1 Reply
Anonymous
Not applicable
Author

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