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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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