topic Disable all cell formatting in QlikView

Disable all cell formatting

Fri, 20 Dec 2013 10:47:18 GMT

I'm using cell formatting to show erroneous data in a chart. This is done by adjusting background colour and text colour in every expression; for example like this for background colour:

=if( (TaskGoLiveDate < TaskCreatedDate) ,red(),)

Now I'd like to add a toggle button to show/disable this formatting. The only way I can think of is to create a variable like vShowFormatting and then add an IF-statement to only show the formatting if the variable is set to a certain value. I can then create a button that toggles this value.

However, I have formatting for a lot of different expressions. So it would take a lot of time to edit each expression one by one. Is there any other way to achieve cell formatting on/off?

Re: Disable all cell formatting

Anonymous — Fri, 20 Dec 2013 10:59:03 GMT

Gustav

Using a variable like you are planning sounds sensible, and yup editing loads of expressions can be right pain. But can be made less painful by, in the QV Desktop :

Settings
Expression Overview

This shows all expressions in one go and allows you to do Find/Replace across all of them.

I would strongly suggest you take a backup copy of qvw first, as using this, especially for the first time, it is possible to destroy things.

Best regards, Bill

Re: Disable all cell formatting

Fri, 20 Dec 2013 20:35:09 GMT

Thanks Bill, I'll just have to do it that way then. Thanks for the tip on the expression editor!