topic Re: How do I color a dimension consisting two fields with same expression? in QlikView

How do I color a dimension consisting two fields with same expression?

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

Hi, I have a dimension based on the formula

IF(len(trim([CONTAINER]))=0,'OFF-LINE','ON-LINE') as OFF_ON_LINE

The expression for the above dimension is count(distinct case#).

How can I color the cells in straight table such a way that for OFFLINE below 70 is red and above 70 is green, and for ONLINE below 110 is red and above 110 is green?

Re: How do I color a dimension consisting two fields with same expression?

YoussefBelloum — Wed, 11 Jul 2018 14:46:27 GMT

Hi,

did you try using the background color expression section of the dimension ?

using an expression like this:

=if(OFF_ON_LINE='OFF-LINE',

if(count(distinct case#)<70,

red(), if( count(distinct case#)>70, green())),

if(count(distinct case#)<110, red(), if(count(distinct case#)>110, green())))

Re: How do I color a dimension consisting two fields with same expression?

vishsaggi — Wed, 11 Jul 2018 14:47:52 GMT

May be this?

= IF(Count(DISTINCT {< OFF_ON_LINE = {'OFF-LINE'} >} Case#) < 70, Red(),

Count(DISTINCT {< OFF_ON_LINE = {'OFF-LINE'} >} Case#) > 70, Green(),

Count(DISTINCT {< OFF_ON_LINE = {'ON-LINE'} >} Case#) < 110, Red(),

Count(DISTINCT {< OFF_ON_LINE = {'ON-LINE'} >} Case#) > 110, Green())

Re: How do I color a dimension consisting two fields with same expression?

haneeshmarella — Wed, 11 Jul 2018 14:50:12 GMT

Converts every cell into red color.

Re: How do I color a dimension consisting two fields with same expression?

haneeshmarella — Wed, 11 Jul 2018 14:50:24 GMT

It says error in expression.

Re: How do I color a dimension consisting two fields with same expression?

YoussefBelloum — Wed, 11 Jul 2018 14:52:49 GMT

just check the expression (parentheses...) this is how you color your cells

Re: How do I color a dimension consisting two fields with same expression?

vishsaggi — Wed, 11 Jul 2018 14:54:56 GMT

Can you share your expression you are using and if possible share your qvw file to work on?

Re: How do I color a dimension consisting two fields with same expression?

haneeshmarella — Wed, 11 Jul 2018 14:55:19 GMT

Oops my bad, forgot that case# is case sensitive. It works, thanks Youssef.

Re: How do I color a dimension consisting two fields with same expression?

haneeshmarella — Wed, 11 Jul 2018 14:56:21 GMT

Thanks for your response Nagaraju, the answer provided by Youssef above worked.

Re: How do I color a dimension consisting two fields with same expression?

YoussefBelloum — Wed, 11 Jul 2018 15:00:42 GMT

You're welcome good luck

Re: How do I color a dimension consisting two fields with same expression?

haneeshmarella — Wed, 11 Jul 2018 16:38:45 GMT

Youssef, Can you help me out here please?

How to put target lines in line graph for dimension with two field and single expression?