topic Table Representation problem in QlikView

Table Representation problem

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Table Representation problem

Anonymous — Mon, 30 May 2016 13:23:31 GMT

Hi Dave Lau,

See attached example.

Kind regards !

Re: Table Representation problem

Marcio_Campestrini — Mon, 30 May 2016 13:55:18 GMT

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.

Re: Table Representation problem

sunny_talwar — Mon, 30 May 2016 19:26:43 GMT

This is great, thanks for introducing this idea.

Best,

Sunny

Re: Table Representation problem

woshua5550 — Tue, 31 May 2016 03:21:00 GMT

你太厉害了！！！！！

This is soooooooooooooo perfect !!!!!!

could you please explain your expression?

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

Re: Table Representation problem

woshua5550 — Tue, 31 May 2016 10:27:10 GMT

yes shown as image is the right way

thank you

Re: Table Representation problem

Anonymous — Tue, 31 May 2016 13:21:28 GMT

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!