Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Designing a Table's Header

Hi All,

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

is there a way to change it?

header.png

thanks!

19 Replies
awhitfield
Partner - Champion
Partner - Champion

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

Not applicable
Author

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

Header and total rows have same background color.

MayilVahanan

Hi

Try like this

Backgroundcolor Expression:

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
punitpopli
Specialist
Specialist

Hi NIRKATZ123‌,

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

Thanks,

Punit

Anonymous
Not applicable
Author

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?

2.png

1.png

awhitfield
Partner - Champion
Partner - Champion

Hi Nir,

can you upload you QVW?

Andy

Anonymous
Not applicable
Author

please find attached my exapmle

w/o section access

awhitfield
Partner - Champion
Partner - Champion

HI Nir,

can you upload again WITHOUT Section Access please?

Andy

Anonymous
Not applicable
Author

done

sorry