topic Re: Straight table background color in QlikView

Straight table background color

deepakkrish — Sat, 16 Nov 2024 00:11:24 GMT

Hi All ,

I am using 2 dimensions and 3 expressions in straight table . My requirement is to change the back ground color based on condition . Can anyone help me to done this .

Dim: Month, Timestamp

Score :

=if(score<=2.5,red(),
if(score>=3.5,green(),Yellow()))

percentage:

=if(percentage<='80%',red(),

if(percentage>='95%',green(),yellow()))

Regards,

Deep.

Re: Straight table background color

Lisa_P — Thu, 06 Aug 2020 07:22:22 GMT

If score and percentage are fields, you need to aggregate - sum(score) ..

If they are column names in the table, it should work out ok.

Re: Straight table background color

deepakkrish — Thu, 06 Aug 2020 07:37:46 GMT

That is not a filed name just a calculation..

Re: Straight table background color

deepakkrish — Thu, 06 Aug 2020 08:03:50 GMT

The expression and condition is correct .

back ground color transparency should be 0% . It working now.

Thanks,

Deep.