topic Re: Background color in QlikView

Background color

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

Hi Experts,

PFA

i want to change background color in pivot table which i marked in single row

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 16:13:59 GMT

I have not seen Any Attachment, Would you attach the qvw file

or, You have to enter for all metrics of BG Color expression like below

If(ProductCode = '30-Day RFs', Green(), Red())

Re: Background color

qlikview979 — Sun, 14 May 2017 17:04:20 GMT

Hi anil,

can you check in above screen shot

i want to change expression back ground color also,it mean "30-Day RFs" back ground color i need to show in blue color.

Rgards

mahesh

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:06:16 GMT

Again Confused to me, Would you share sample to look the same?

Re: Background color

qlikview979 — Sun, 14 May 2017 17:14:33 GMT

Simple ,i want to change Expression back ground color

Ex:-

sum(sales)

100

200

300

here i want to change back ground color for sum(sales)

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:19:02 GMT

True that is how my first reply works. Or just use for Sum(Sales) color as Blue() like below. Expand the expression and then Give Blue() for BG Color in Definition. It should work

Re: Background color

qlikview979 — Sun, 14 May 2017 17:22:50 GMT

not like that,

i want to change Lable back ground color in expression tab

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:25:24 GMT

Like this?

Re: Background color

vishsaggi — Sun, 14 May 2017 17:26:08 GMT

Why dont you use Customer Format Cell using Ctrl+G and select a label right click Custom Format and change background color.

Re: Background color

qlikview979 — Sun, 14 May 2017 17:27:50 GMT

Exactly,but here when i drag the expressions its not working

Re: Background color

qlikview979 — Sun, 14 May 2017 17:29:35 GMT

Hi VN,

i tried, it was taking same color in all expressions ,but i need every one expression different color

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:31:55 GMT

Drag means? Changing the columns in UI by help of Mouse. Not sure, I understand fully over here

Re: Background color

qlikview979 — Sun, 14 May 2017 17:35:34 GMT

In pivot table ,Here i am taking columns names as rows.

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:38:34 GMT

It would be better if you provide sample to troubleshoot where you facing issue. Even though, In my application transpose happens seems working to me

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:40:10 GMT

Check this?

Changing color for individual column header in a straight table

Note: I would highly recommend you to mark as Helpful so that we can understand easily where you need

Re: Background color

qlikview979 — Sun, 14 May 2017 17:43:04 GMT

Here i want to show blue for sum(profit) like what you shown.

sum(value) i want to show in green color ,i mean i have to show every expression lable with different color

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:45:11 GMT

I already replied for that, Check below reply

FYI, Changing color for individual column header in a straight table

Re: Background color

qlikview979 — Sun, 14 May 2017 17:46:34 GMT

I want in Pivot table Not straight table

Re: Background color

Anil_Babu_Samineni — Sun, 14 May 2017 17:47:58 GMT

I wonder, Whether you can do same thing in Qlikview for Pivot Object. Let him share few more detail thoughts

gwassenaar‌