Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

BG colors in Dimensions URGENT

Hi all,

So i made a pivot table and for 1 dimension, i made a conditional color for the background.

problem is: it also fills the 'Total' field.

how do i make this go away?

see attached image for clarification..

thanks"

Dick

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

If(rowno()=0 or isNull(rowno()),Null(),If(Sum(Sales) > 300,Red(),Yellow()))

147041.png

View solution in original post

5 Replies
Highlighted
Not applicable

try this go to settings->user preference->design

and change default styling mode default to advanced

snap1.png

and now right click on the total cell and click on custom format cell and change the Background color for the total cellsnap2.png

Highlighted
Master III
Master III

What is your background color expr?

Highlighted
Champion
Champion

try this

if ( expression > 1,red(),green())

Vikas

Highlighted
Champion
Champion

pfa

Highlighted
Master III
Master III

If(rowno()=0 or isNull(rowno()),Null(),If(Sum(Sales) > 300,Red(),Yellow()))

147041.png

View solution in original post