topic Re: Background color cell in QlikView

Background color cell

Anonymous — Tue, 18 Feb 2014 17:51:07 GMT

Hi guys,

Is it possible to fix my background color?

Sometimes I have the same color in cells, because it skips cells without data.

Please see my files.

regards,

Re: Background color cell

MK_QSL — Tue, 18 Feb 2014 17:56:17 GMT

Go to Style and select and style..

Also select Stripes every 1 rows

Re: Background color cell

Anonymous — Tue, 18 Feb 2014 17:57:52 GMT

Nothing changed

Re: Background color cell

Tue, 18 Feb 2014 18:04:01 GMT

Actually qv skips the format for empty cells.

Setting the presentation panel without "Supress Zero Values" and with "Populate Missing Cells" helps a little but, in many cases, doesn't solve the problem.

I usually create zero values in script or use NumSum(Sum(...)) in the chart expressions so you always have data in every cells.

Regards,

Fernando

Re: Background color cell

maxgro — Tue, 18 Feb 2014 18:08:02 GMT

I think Manish is right; why you say nothing changed?

comment your background color expression, follow Manish post, .....

or I'm missing someting?

Re: Background color cell

chiru_thota — Tue, 18 Feb 2014 18:09:45 GMT

Hi ,

I could see a condition on expression background color and it is the reason

If(Even(RowNo()), rgb(220,220,220), rgb(238,233,233))

By fixing it you can get rid of the cell color.

Thanks,

Chiru

Re: Background color cell

Anonymous — Tue, 18 Feb 2014 18:12:07 GMT

Please see my screen shot

Re: Re: Background color cell

maxgro — Tue, 18 Feb 2014 18:26:11 GMT

please see attachment

regards

Re: Background color cell

MK_QSL — Tue, 18 Feb 2014 18:31:41 GMT

You need to remove background color expression under both dimensions and expression

Re: Background color cell

Anonymous — Tue, 18 Feb 2014 18:36:15 GMT

I resolved it. Thanks, But I'd like make colours of cells a bit darker.

Because brightness of my computer is high and I couldn't see them.

Re: Background color cell

MK_QSL — Tue, 18 Feb 2014 18:38:23 GMT

Select style as dark

Re: Background color cell

Anonymous — Tue, 18 Feb 2014 18:40:58 GMT

I have designers, They want to keep colors of my company

Re: Background color cell

maxgro — Tue, 18 Feb 2014 18:56:10 GMT

on the chart, right click and then choose custom format cell

select a row and set the background color you like

select the below (above) row and set to another background color

Re: Background color cell

MK_QSL — Tue, 18 Feb 2014 19:04:58 GMT

User preference >> Design >> Always show design menu item...

Select above if you are unable to see Customer Format Cell after right clicking any cell of your table...

Re: Background color cell

Tue, 18 Feb 2014 19:18:38 GMT

OMG this one changed my life totally! Thanks man!

I didn´t know this menu!

Re: Background color cell

Anonymous — Mon, 24 Feb 2014 20:51:52 GMT

"Stripes every" works only in Straight table

Custom format cell colors whole Dimension in Pivot table

Use Background expression like If(Even(RowNo()), rgb(220,220,220), rgb(238,233,233)) doesn't work with sort by Y-value.

In Pivot table 1 dimension and 1 expression sorting by Y-value possible to color each 2nd row?

Thanks,