topic If statement in QlikView

If statement

Fri, 18 Jan 2013 14:42:18 GMT

Hi -

I am working with a table where i need to format in Bold specific rows. I am trying to achieve this using if statement within the 'Text Format' properties.

if(Consolidated='Revenue','',if(Consolidated='Cost of Goods Sold','',if(Consolidated='Taxes','', ' ' )))

For some reason this expression only highlights first row 'Revenue' and does not work the rest of the rest of the fields.

What am I doing wrong?

Please help

Thank you!

Re: If statement

Fri, 18 Jan 2013 15:10:18 GMT

Hi,

how many Revenues, etc. are there in the table?

Have you checked for typos?

Try encircling the error by copying that column as test versions using one if statement per column.

Ciao

Klaus

Re: If statement

shree909 — Fri, 18 Jan 2013 15:51:05 GMT

try

if(Consolidated='Revenue','') or

if(Consolidated='Cost of Goods Sold','') or

if(Consolidated='Taxes','',' ' )