how to solve this in QlikView?

[Anonymous]

The customer is looking for something like this:

The hard thing in this is that the first column are the expressions (vertically viewed).

On top are 2 dimensions (Quarter and Type).

If there are only 'numbers' shown this is not hard to do ... but the customer really needs some sort of traffic lights columns in between.

Anyone got suggestions how to fix this in any way?

thx in advance!!

Anita

[christian77]

Hi:

I usually do that like Patrick is telling you. Have on mind that images are not exportable to excel. To solve this problem, use UNICODE symbols with colors.

If you have a pivoted dimension, as far as I see, you need 3 expressions.

It is possible to create fake dimensions in your script to build some objects. If you need a 2nd dimension inside Quarter, create an inline dim, wit 3 values A, B, C and then go like:

if(FakeDim='A', A-expression, if(FakeDim='B', ...

Salutes.

[mr_ramshini]

HI

i have a question?

How i can set lights of traffic lights in gauge chart at qlik view?

thanks