topic Re: Highlight Certain Fields in QlikView

Highlight Certain Fields

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

Hi,

I am having an issue highlighting certain fields in my pivot table.

I have a dataset like this.

% of cars

I am using the following IF statement to arrange them into groups within the pivot.

=if ([% of Cars] <5, '<5%',

if ([% of Cars] <=7 , '6-7%',

if ([% of Cars] <=8 , '7-8%',

if ([% of Cars] <=9, '8-9%',

if ([% of Cars] <=10, '9-10%',

if ([% of Cars] >10, '>10%',

))))))

The script works fine in sorting them into their designated fields. However I would like certain fields such as the <=10 and >10 to be in Red. I would like <5 and <=7 to be green. Does anyone know how to achieve this? I have tried for quite a while and I can not seem to find a solution.

Re: Highlight Certain Fields

Anil_Babu_Samineni — Wed, 13 Sep 2017 15:49:14 GMT

May be this?

Re: Highlight Certain Fields

Anonymous — Thu, 14 Sep 2017 07:15:28 GMT

Hi,

You can set this in the background colour of the dimension

Re: Highlight Certain Fields

Anonymous — Thu, 14 Sep 2017 09:57:11 GMT

This doesn't work for me.

Say you had

=if ([% of Cars] <5, '<5%',

if ([% of Cars] <=7 , '6-7%',

if ([% of Cars] <=8 , '7-8%',

if ([% of Cars] <=9, '8-9%',

if ([% of Cars] <=10, '9-10%',

if ([% of Cars] >10, '>10%',

))))))

how would i colour each cell. so for >10 red ,<= 9 blue etc. your trick doesn't work as i am using the script shown above.

Re: Highlight Certain Fields

Anil_Babu_Samineni — Thu, 14 Sep 2017 10:00:30 GMT

Like this?

Re: Highlight Certain Fields

Anonymous — Thu, 14 Sep 2017 10:06:24 GMT

What is the as Field Inline?

This is my current script in the dimensions.

=if ([% of cars] <5, '<5%',

if ([% of cars] <=7 , '6-7%',

if ([% of cars] <=8 , '7-8%',

if ([% of cars] <=9, '8-9%',

if ([% of cars] <=10, '9-10%',

if ([% of cars] >10, '>10%',

))))))

From here how would i assign certain colors?

Re: Highlight Certain Fields

Anil_Babu_Samineni — Thu, 14 Sep 2017 10:08:27 GMT

Have you opened my script?

LOAD *, if ([% of cars] <5, '<5%',if ([% of cars] <=7 , '6-7%',if ([% of cars] <=8 , '7-8%',if ([% of cars] <=9, '8-9%',if ([% of cars] <=10, '9-10%',

if ([% of cars] >10, '>10%')))))) as Field Inline [

% of cars

];

Re: Highlight Certain Fields

Anonymous — Thu, 14 Sep 2017 10:12:43 GMT

Yes i did - However , the data is being read in from a excel file with 100s of lines so i cannot add the "as Field Inline Script in the main script editor - I am adding the Script from the Chart properties -> Dimensions then adding my script

Re: Highlight Certain Fields

Anil_Babu_Samineni — Thu, 14 Sep 2017 10:15:03 GMT

Please post sample application and design colors for cells?