topic Background Color Expression not working as expected in Pivot table in QlikView

Background Color Expression not working as expected in Pivot table

jagan — Mon, 17 Nov 2014 05:16:36 GMT

Hi All,

I am getting an issue in applying the Background color to a pivotted dimension (Branch in attached file). I am using below expression

in Background color expression, but it is working Branch values BR002 and BR003, I think this is because of all values in first record,

=Pick(Match(Branch, 'BR001', 'BR002', 'BR003'), Red(), Green(), Blue())

If I select Product X then all background colors are applying as expected since it has values for all Branches.

I think it is bug, please let me know if there is any solution or fix for this.

Henric Cronström Josh Good please look into this issue.

Thanks in advance.

Regards,

Jagan.

Re: Background Color Expression not working as expected in Pivot table

ashfaq_haseeb — Mon, 17 Nov 2014 05:31:19 GMT

Hi,

I think it could be a bug with pivot table.

Works fine with straight table..!

May be upgrade to SR9 will fix this.

Did you try with SR9 ?

Regards

ASHFAQ

Re: Background Color Expression not working as expected in Pivot table

tresB — Mon, 17 Nov 2014 05:31:35 GMT

Hi Jagan,

Two points to be noted:

If your sencond dimension contains null (possibly only against the first dimension) then the issue comes.

I have added some more values to remove nulls in the table and it worked fine.

2. If you pull down your dimension to rows it works as expected (even with nulls)

But yes, an explanation(may be from qlik) of the behavior would be very helpful.

Re: Background Color Expression not working as expected in Pivot table

jagan — Mon, 17 Nov 2014 05:36:08 GMT

Hi,

If you add some rows it works as expected, I did the same by adding 0.0000000001 for BR002 and Product A, it is working as expected for BR002, but in my real data I have many dimensions and thousands of values in each dimension. So it is not possible to change changing the data in my real application.

Regards,

jagan.

Re: Background Color Expression not working as expected in Pivot table

Josh_Good — Mon, 17 Nov 2014 17:52:58 GMT

Hi Jagan,

I took a quick look and wasn't able to resolve the issue.

-Josh

Re: Background Color Expression not working as expected in Pivot table

jagan — Tue, 18 Nov 2014 03:02:34 GMT

Hi jgd,

How to proceed on this?

Regards,

Jagan.

Re: Background Color Expression not working as expected in Pivot table

Josh_Good — Tue, 18 Nov 2014 03:36:17 GMT

Jagan,

I would recommend you contact support. This is the best way to determine if this is a bug or if it is working as designed.

-Josh

Re: Background Color Expression not working as expected in Pivot table

jagan — Tue, 18 Nov 2014 03:42:51 GMT

Hi Josh,

We already raised a ticket to support, just wanted to check whether is there any workaround for this.

Regards,

jagan.

Re: Background Color Expression not working as expected in Pivot table

Josh_Good — Tue, 18 Nov 2014 03:51:44 GMT

Jagan,

I wasn't able to find one or figure one out.

Sorry,

Josh

Re: Background Color Expression not working as expected in Pivot table

jagan — Tue, 18 Nov 2014 04:01:34 GMT

Hi Josh,

I too tried for the past few days without any luck. Within how many days Qlik will resolve this? I raised the ticket few days back.

Regards,

jagan.

Re: Background Color Expression not working as expected in Pivot table

Josh_Good — Tue, 18 Nov 2014 04:20:09 GMT

Hi Jagan,

You should have received an initial response from our support team indicating what the next steps would be on the case and your case number. If that did not happen, then something went wrong with your case and I recommend you resubmit the case. If you do have a case number then I recommend you contact support and reference the case number.

I apologized that I cannot help further. Support is the part of our organization best equiped to deal with the issue you are having.

-Josh

Re: Background Color Expression not working as expected in Pivot table

jagan — Tue, 18 Nov 2014 05:30:54 GMT

Hi Josh,

This is the reply from Qlik This bug was closed as working as designed., but the design should not be like this right? I am just applying based on the dimension value not by Expression value, it should work based on the dimension since we are giving this background color condition to Dimension.

Regards,

Jagan.

Re: Background Color Expression not working as expected in Pivot table

Josh_Good — Tue, 18 Nov 2014 05:44:36 GMT

Jarag,

Per my prevous post, Support is best equipped to assist you further. I recommend you direct your inquiry there. If you have follow up questions they can assist.

-Josh

Re: Background Color Expression not working as expected in Pivot table

jagan — Tue, 18 Nov 2014 05:56:43 GMT

Ok, Thanks Josh for your support on this.

Regards,

Jagan.

Re: Background Color Expression not working as expected in Pivot table

hic — Tue, 18 Nov 2014 09:23:16 GMT

This is a known issue (that I don't like either). The only work-around that I can see, is to make sure there are values in the first row of the pivot table. Which I realize may be difficult to achieve...

What was the Case ID?

HIC

Re: Background Color Expression not working as expected in Pivot table

jagan — Tue, 18 Nov 2014 09:58:49 GMT

Hi,

BugID: 61584

Regards,

jagan.

Re: Background Color Expression not working as expected in Pivot table

Wed, 19 Nov 2014 13:04:01 GMT

Any news about this issue?

Re: Background Color Expression not working as expected in Pivot table

jagan — Wed, 19 Nov 2014 13:18:58 GMT

No response yet.

Regards,

Jagan.

Re: Background Color Expression not working as expected in Pivot table

Wed, 19 Nov 2014 13:37:39 GMT

Attached is a screenshot I have two rows with same data one is applying the format and the other is not.

Re: Background Color Expression not working as expected in Pivot table

aveeeeeee7en — Wed, 26 Nov 2014 07:30:33 GMT

Sir

It's a Bug. I have also done a lot of R&D on it.

But the strange thing is the Code =Pick(Match(Branch, 'BR001', 'BR002', 'BR003'), Red(), Green(), Blue()) works Perfectly on Expressions but when we apply same Code on Dimension this doesn't work Properly. Only Fill Color on First Dimension value.

Also, when you Select your Dimension Value one by one, than it shows the Correct Color.

Regards

Av7eN