Table Representation problem

[woshua5550]

Hi all

i need a table looks like this

but actually the first row is text object so that it can't be scrolled by the scroll bar in table

i try to fix this problem by using pivot,but i got another problem

the table is as follow

the problem is that i can't display "Type T2" as traffic light because all the data is based on one expression

it seems impossible to chose two display options in one expression

is there a prefect solution to deal with it?

thanks a lot.

[Anonymous · Accepted solution]

Hi Dave Lau,

See attached example.

Kind regards !

[Marcio_Campestrini]

Hi Dave

Have you tried to change your column to show an image? If you have the same rules for each type/subtype, you just need to put these roles in the expression.

[sunny_talwar]

This is great, thanks for introducing this idea.

Best,

Sunny

[woshua5550]

你太厉害了！！！！！

This is soooooooooooooo  perfect !!!!!!

could you please explain your expression?

what's the "qmem://<bundled>/BuiltIn/led_r.png" mean ?

[woshua5550]

yes  shown as image is the right way

thank you

[Anonymous]

Hi Dave,

Thanks!!.

"qmem://<bundled>/BuiltIn/led_r.png" is a bundled image, that is preloaded on QlikView. You can load your images with bundled load.

My expresion says that:

If not is T1, show image, else show number.

I have calculated whether it is green or red depending on the sum calculation.

Thanks!