topic Re: Custom Format cell variable color expression in QlikView

Custom Format cell variable color expression

Mon, 20 Jan 2014 14:07:27 GMT

In have to paint a line on one table depending on the dimension value. I'm trying to set a expression to do it in custom format cell. Expressions in custom format cell are linked to the dimension? Anybody can help me?

Re: Custom Format cell variable color expression

marcus_sommer — Mon, 20 Jan 2014 16:03:48 GMT

Not really clear what do you want to do. You could set custom cell-formats within dimensions and expressions per click on the plus-sign and insert an expression like: if(CONDITION, red(), blue()). If you want show lines or bars within a table you could choose gauge-charts or mini-charts as expressions-type. Alternatively you could create bars or lines within a cell per repeat() function.

- Marcus

Re: Custom Format cell variable color expression

Mon, 20 Jan 2014 16:20:32 GMT

Hi Victor!

See Chart Properties: Visual Cues:

Visual cues are used for highlighting expression values and are displayed by applying a different font style,

font color and/or cell color.

Is this?

Re: Custom Format cell variable color expression

Mon, 20 Jan 2014 16:30:36 GMT

Hey Victor,

Can you post a sample qvw with some dummy data and maybe snap shots of your requirement if possible.

That would be helpful in addressing your questions.

Thanks

Re: Custom Format cell variable color expression

Fri, 31 Jan 2014 09:40:40 GMT

I'm sorry I was talking about the line between two cells in vertical in a table / pivot table. Need that line to have variable color related to a dimension value. Is that possible? That's why I'm talking about Custom Cell format. The only place in which separator line format can be changed is in that place.

The Green line as shown in image

Re: Re: Custom Format cell variable color expression

Fri, 31 Jan 2014 17:41:40 GMT

Hey Victor,

Check out the attached file and see if it helps. The coloring is based on Dimension.

Re: Custom Format cell variable color expression

Sat, 01 Feb 2014 17:47:17 GMT

This is correct Answer

Re: Re: Custom Format cell variable color expression

Mon, 03 Feb 2014 12:04:47 GMT

I'm sorry Ajay but that's not the idea I was looking for. I want to change the "separator line" between cells. The darker green line shown in the screenshot. thanks