topic How to highlight the product code ? in QlikView

How to highlight the product code ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: How to highlight the product code ?

sunny_talwar — Thu, 05 May 2016 10:05:01 GMT

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

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

Re: How to highlight the product code ?

sunny_talwar — Thu, 05 May 2016 10:11:42 GMT

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

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

Re: How to highlight the product code ?

sunny_talwar — Thu, 05 May 2016 10:19:51 GMT

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

Re: How to highlight the product code ?

avinashelite — Thu, 05 May 2016 10:29:37 GMT

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())