topic Re: Designing a Table's Header in QlikView

Designing a Table's Header

Anonymous — Wed, 20 May 2015 09:15:35 GMT

Hi All,

colors of the headers are effecting the total row as well,

is there a way to change it?

thanks!

Re: Designing a Table's Header

awhitfield — Wed, 20 May 2015 09:27:49 GMT

Hi Nir,

Firstly, you need to have either 'Always Show Design Menu Items' ticked in User Preferences - Design Tab' OR View > Design Grid.

Then, right click on the object and select Custom Cell format and you go do what you wish, e.g.

HTH Andy

Re: Designing a Table's Header

Wed, 20 May 2015 09:28:11 GMT

Even i have tried this in my application using custom format cell.

Header and total rows have same background color.

Re: Designing a Table's Header

MayilVahanan — Wed, 20 May 2015 09:30:41 GMT

Try like this

Backgroundcolor Expression:

=If(RowNo() = 0, White(), LightGray())

Re: Designing a Table's Header

punitpopli — Wed, 20 May 2015 10:06:03 GMT

Hi NIRKATZ123‌,

Can you share the sample file, you are working on?

Thanks,

Punit

Re: Designing a Table's Header

Anonymous — Wed, 20 May 2015 10:29:43 GMT

these is what i got by your suggestions:

1 I have tried using the RowNo() function, as MayilVahanan, but row number =0 is not the total row

2 I tried Andrew's suggestion but these cells have no total value, so it is not exactly like in your example (as kpeswani‌ claimed)

3 I tried setting a total value like in the pic below, but i have no clue what it means

what do you think?

Re: Designing a Table's Header

awhitfield — Wed, 20 May 2015 10:32:32 GMT

Hi Nir,

can you upload you QVW?

Andy

Re: Designing a Table's Header

Anonymous — Wed, 20 May 2015 10:51:31 GMT

please find attached my exapmle

w/o section access

Re: Designing a Table's Header

awhitfield — Wed, 20 May 2015 11:01:10 GMT

HI Nir,

can you upload again WITHOUT Section Access please?

Andy

Re: Designing a Table's Header

Anonymous — Wed, 20 May 2015 11:32:10 GMT

done

sorry

Re: Designing a Table's Header

awhitfield — Wed, 20 May 2015 12:07:14 GMT

Hi Nir,

still getting access denied

Andy

Re: Designing a Table's Header

Anonymous — Wed, 20 May 2015 12:37:55 GMT

please try again (forgive my lack of experience with these things)

Re: Designing a Table's Header

awhitfield — Wed, 20 May 2015 13:02:42 GMT

Here you go, should of said that you need to select the actual cell you want to apply the customer colour to, I have also changed the null symbol to be '' blank on the presentation tab so you don't get the - displayed in the cell

HTH Andy

Re: Designing a Table's Header

Anonymous — Wed, 20 May 2015 13:10:09 GMT

1 NULL value, great!

2 cell color, i am looking on your qvw, but the color is still the same....

Re: Designing a Table's Header

awhitfield — Wed, 20 May 2015 13:18:42 GMT

Sorry, I thought that was what you wanted! What colour should they be? The same as the other rows it the total columns?

Like this:

If so, see attached, again

Andy

Re: Designing a Table's Header

Wed, 20 May 2015 13:20:20 GMT

In QVW shared by andrew, you can change respective cell color using custom format cell.

Re: Designing a Table's Header

Anonymous — Wed, 20 May 2015 14:11:00 GMT

how are you doing this?

1 I am right clicking the grey cell (under the "Email" cell)

2 Select "Custom Format Adjust"

3 choose "Background Color", and then set it to a different color

that's what i get:

Re: Designing a Table's Header

awhitfield — Wed, 20 May 2015 14:34:20 GMT

Yep that's all !

andy

Re: Designing a Table's Header

Anonymous — Mon, 25 May 2015 07:46:14 GMT

I still can't change the color,

I am using version 11 SR9, are you using it too by any chance?

Re: Designing a Table's Header

ankitaag — Mon, 25 May 2015 08:31:19 GMT

Hi Nir,

You can write the background expression as =if(Dimensionality()=0,RGB(255,255,255),RGB(245,245,245))

where the dimensionality()=0 represents the Total value