topic Re: Custom format to cell in QlikView

Custom format to cell

Anonymous — Mon, 08 Feb 2016 17:39:19 GMT

I am unable to change color for below location

How can I?

I am unable to attached sample QV, as company policy

Anonymous — Mon, 08 Feb 2016 17:41:22 GMT

This code create table

T1:
LOAD * INLINE [
C1, C2, C3, C4
A, FA, 11, V1
B, FB, 22, V2
C, FC, 33, V1
A, FC, 44, V2
B, FB, 55, V2
C, FA, 66, V1
];

Anonymous — Mon, 08 Feb 2016 18:34:32 GMT

in a Pivot table you can do it:

Menu View: select design grid

Position your table with the cell you want

right mouse click and custom Format cell

Change the colour of the specified cell to your colour

Anonymous — Mon, 08 Feb 2016 19:51:45 GMT

Hi Rudolph

I appreciate your suggestion, but I am unable to change color for specific location where green circle is

Yhanks

Anonymous — Mon, 08 Feb 2016 20:06:09 GMT

do you see the custom Format cell menu? (right menu of my Picture)

can you Position this cell in the menu custom format cell?

Anonymous — Mon, 08 Feb 2016 20:13:09 GMT

Yes I can see Custom Format Cell, I can position that particular cell as well but color change for underneath cell (C2) not like I mentioned

Anonymous — Mon, 08 Feb 2016 20:30:19 GMT

i thougth you wanted the cell which you encircled? but you want cell with C2 colored?

if it is one Dimension with C1, C2, C4 it won't be possible

Anonymous — Tue, 09 Feb 2016 13:14:30 GMT

Thanks Rudolph for help