topic Re: Color declaration in Pivot cells in QlikView

Color declaration in Pivot cells

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

Hi Folks,

I am having a pivot table and having a dimension as time interval.

I need to write a background color expression like when time interval is <= 00:15:00 ,green() and >00:15:00,Red().

I tried like below it's directly taking the else condition,can anyone advise me what is the issue and proper solution.

Background color expression:

if($(vACD_Agent_NotReadyDuration)<='00:15:00',RGB(102,255,102),

if($(vACD_Agent_NotReadyDuration)>'00:15:00',RGB(255,121,121)))

Thanks

Krishna

Re: Color declaration in Pivot cells

kaushiknsolanki — Mon, 19 Feb 2018 06:55:19 GMT

Hi,

Try this.

if($(vACD_Agent_NotReadyDuration)<=Maketime(00,15,00),RGB(102,255,102),

if($(vACD_Agent_NotReadyDuration)>Maketime(00,15,00),RGB(255,121,121)))

Regards,

Kaushik Solanki

Re: Color declaration in Pivot cells

krishna20 — Mon, 19 Feb 2018 07:13:12 GMT

Hi Kaushik,

Thanks for your reply. No change.

Re: Color declaration in Pivot cells

kaushiknsolanki — Mon, 19 Feb 2018 07:20:07 GMT

Hi,

Can you tell us what value your variable has and how are you assigning value to variable.

Regards,

Kaushik Solanki

Re: Color declaration in Pivot cells

krishna20 — Mon, 19 Feb 2018 07:23:12 GMT

variable is storing the below expression .

interval((sum({<eventtype={'2'}>}EventDuration))/86400,'hh:mm:ss')

Re: Color declaration in Pivot cells

krishna20 — Mon, 19 Feb 2018 08:48:07 GMT

Hi,

Can anyone advise me on this??

Re: Color declaration in Pivot cells

kaushiknsolanki — Mon, 19 Feb 2018 08:49:18 GMT

Hi,

Can you share sample data.

Regards,

Kaushik Solanki

Re: Color declaration in Pivot cells

rubenmarin — Mon, 19 Feb 2018 08:57:27 GMT

Hi Kalyan, it seems ok, just ensure that the variable expression doesn't have an starting equal sign, with an equal sign it will evaluate globally and return the same result for all cells.

By the expression, EventDuration should be received in seconds.

In any other case a sample will be nice to see what's happening.

Re: Color declaration in Pivot cells

Anil_Babu_Samineni — Mon, 19 Feb 2018 09:12:48 GMT

Is this return $(vACD_Agent_NotReadyDuration) for data points?

Re: Color declaration in Pivot cells

krishna20 — Mon, 19 Feb 2018 10:13:49 GMT

Hi All,

Issue resolved. That was a self variable mistake in the background expression. Thanks to all for your valuable suggestions.