How to highlight the product code ?

[suvechha_b]

Hi all,

there are two table "POTSO" and "NewProduct" in the qlikview model.

My requirement is ,

I need to highlight the [Product Code] in the report with yellow background color.

which are present in "NewProduct" table.

sample model attached.

See screenshot,

required output :

The product code should be highlight in yellow color.

Thanks,

[sunny_talwar]

The whole dimension needs to be colored yellow? Like this?

My bad - Only Product Code which are present in one table. WIP

[sunny_talwar · Accepted solution]

May be this as the background color for your Product/Code dimension

=If(Len(Trim(DR)) > 0, Yellow())

[sunny_talwar]

Just so you know that use a field in place of DR which you know would never be null from NewProduct table. Or may be create a field like RowNo() as Key in the NewProduct table which will never be null because this expression is based on the fact that we are checking if the field is not Null, color the dimension Yellow. Since this is the only table it should be present in, for any other product it would be null. But if for some reason it is null in NewProduct table itself, you won't see the color.

I hope all this made sense

[avinashelite]

Try like this

Temp:

Mapping LOAD

Product_Key,

Product_Code

resident

NewProduct;

// In the Product table add a new flag

Product:

LOAD ....

if(len(trim(Applymap('Temp',[Product Code],null())))>0,1,0) as Background_flag

Then go to Product/code dimension  >click on + mark> background color > if(Background_flag=1,yellow())