topic Re: background color in QlikView

background color

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

I have created one pivot table and pivoting dimension to header, Once i pivoting dimension then background color automatically changes to white however i want dimension is in amber color, without pivoting its showing amber background.

Thanks,

Villyee

Re: background color

Gysbert_Wassenaar — Tue, 29 Mar 2016 12:16:42 GMT

Please post a small qlikview document that show the problem.

Re: background color

robert_mika — Tue, 29 Mar 2016 12:26:44 GMT

Maybe this will help:

How to use - Dimensionality()

Re: background color

vanderson009 — Tue, 29 Mar 2016 12:50:03 GMT

PFA attached test application, here i am trying to change background color of header 'AAAA' as red but it not working.

Thanks,

Villyee

Re: background color

awhitfield — Tue, 29 Mar 2016 13:37:05 GMT

Hi villyee,

Check out the following thread, it may be useful:

https://community.qlik.com/message/1004404#1004404

HTH

Andy

Re: background color

vanderson009 — Tue, 29 Mar 2016 13:53:16 GMT

Dimensionality is not working in my scenario, i tried it.

I want header 'AAAA' color as red, however its not appearing cause that column having one null record.

Thanks,

Villyee

Re: background color

vanderson009 — Tue, 29 Mar 2016 13:53:28 GMT

Dimensionality is not working in my scenario, i tried it.

I want header 'AAAA' color as red, however its not appearing cause that column having one null record.

Thanks,

Villyee

Re: background color

awhitfield — Tue, 29 Mar 2016 13:58:24 GMT

You could cheat by setting custom cell format to the Type row

Re: background color

vanderson009 — Tue, 29 Mar 2016 14:01:44 GMT

I tried custom color as well but not getting desired output.

I want color depending on Type, means if AAAA then red, if BBBB then green

Re: background color

Gysbert_Wassenaar — Tue, 29 Mar 2016 14:44:04 GMT

Disable the Suppress Zero-Values option on the presentation tab.

Re: background color

awhitfield — Tue, 29 Mar 2016 14:49:26 GMT

Ha ha, far too easy!

Re: background color

awhitfield — Tue, 29 Mar 2016 14:52:26 GMT

Do as gwassenaar‌ uggested earlier in the thread!

Andy

Re: background color

vanderson009 — Wed, 30 Mar 2016 12:43:01 GMT

Hi Gysbert,

I tried it in test application that i have uploaded here, and its working perfect.

however i am worried cause its not working in my actual scenario.

Thanks for your valuable help.