Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How do I change the format of a row in a table once it meets a certain criteria?

What is the correct defenition to use if i want a certin row which meets a criteria eg:

if(Space <> 's', Sum ({<GlYear = {$(=Max(GlYear)-1)}>} BeginYearBalance)/1000,Sum ({<GlYear = {$(=Max(GlYear)-1)}>} BeginYearBalance )/1000)

I want the result of the formula to show as bold if space=s and also the background to be grey.

1 Solution

Accepted Solutions
danielrozental
Honored Contributor II

Re: How do I change the format of a row in a table once it meets a certain criteria?

You need to use the auxiliar expressions (not sure what the term is please see the image).

img9.png

In the background color expression try something like if(Space = 'S',lightblue(), white())

In the text format expression try if(Space = 'S','<B>')

1 Reply
danielrozental
Honored Contributor II

Re: How do I change the format of a row in a table once it meets a certain criteria?

You need to use the auxiliar expressions (not sure what the term is please see the image).

img9.png

In the background color expression try something like if(Space = 'S',lightblue(), white())

In the text format expression try if(Space = 'S','<B>')

Community Browser