topic Re: pivot table dimension background color issue in QlikView

pivot table dimension background color issue

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

Hi All,

Below is the pivot table that we need create in application based on the attached Source data. For the Field Priority i need to display a background colours based on the field value.

If the value is 1,2 -> red()

3,4 -> yellow()

others-> green()

i tried this through dimension background color if conditions, pick match functions and Custom Format cell colors but not working as excepted. Please help me to achieve the output as expected.

Attached the Qvw file for reference.

Re: pivot table dimension background color issue

Colin-Albert — Fri, 10 Nov 2017 16:57:05 GMT

What expression are you using for the background colour?

These expressions work for the dimension background colour.

Click [+] to expand the dimension options next to the dimension name.

Try

If(match(Priority, 1, 2) , red(),

If(match(Priority, 3,4) , yellow(), green()

))

If(Priority <=2 , red(),

If(Priority <=4, yellow(), green()

))

Re: pivot table dimension background color issue

ashok1203 — Fri, 10 Nov 2017 18:30:49 GMT

Hi Colin,

Thanks for response, i have tried by using the above expression but not getting the output as expected.

If i select any value in Priority then it was showing correct color as per given condition but by default it was not expected. Please use the above attached data in sample application and help me in this regard.

Thanks

Re: pivot table dimension background color issue

ashok1203 — Sat, 11 Nov 2017 09:13:18 GMT

Guys, Any one help me on this thread.

Re: pivot table dimension background color issue

Colin-Albert — Sat, 11 Nov 2017 09:37:24 GMT

Can you show your colour expression and a screenshot of the result.

Re: pivot table dimension background color issue

ashok1203 — Sat, 11 Nov 2017 09:53:42 GMT

The screenshot of result i am getting is above mentioned thread screenshot.

The condition i am using is

If(priority=1 or priority=2, red(),

If(priority=3 or priority=4, yellow(),

Green()))

I tried by using the pick match and some other if match statements.

When i use the same condution in straight table it was working, in pivot also it was working if we display the data in normal, when ever i am dragging the field from row to column it was showing this mentioned screen error.

Re: pivot table dimension background color issue

nevilledhamsiri — Sun, 12 Nov 2017 16:46:42 GMT

Dear!

Please see how this may fit in to your requirement!

Regards

Neville

Re: pivot table dimension background color issue

ashok1203 — Mon, 13 Nov 2017 05:05:21 GMT

Hi Neville,

Thanks for your response. I have a around 420 items in that field. So, i can't implement different different expressions for all those.

Re: pivot table dimension background color issue

ashok1203 — Mon, 13 Nov 2017 13:12:29 GMT

stalwar1‌ gwassenaar‌ please try to help me on this

Re: pivot table dimension background color issue

sunny_talwar — Mon, 13 Nov 2017 13:15:48 GMT

Do you need this?

Uncheck 'Suppress Zero Value' on the presentation tab

Re: pivot table dimension background color issue

ashok1203 — Mon, 13 Nov 2017 13:57:10 GMT

Thanks Sunny

Re: pivot table dimension background color issue

ashok1203 — Fri, 17 Nov 2017 10:50:42 GMT

Sunny, I am developing the same kind of reports.For some of the reports i am getting correct output as per your response but still for some of the reports i am getting the output as expected.

Re: pivot table dimension background color issue

sunny_talwar — Fri, 17 Nov 2017 12:06:25 GMT

Would you be able to share an example?