topic Re: Using shapes in straight table in QlikView

Using shapes in straight table

Anonymous — Thu, 14 Jun 2018 10:10:50 GMT

I Have to show circle symbol in table as separate column.

eg:I have status column which have values like green,red,amber.

now i need to create a column with circle symbol(but it has to be like if the status is green the circle should be in green,red circle for red status etc.)

Please help me out here.

Attached the example.

Thanks

Re: Using shapes in straight table

jwjackso — Thu, 14 Jun 2018 10:40:56 GMT

In the column that will show the circle (image), change the representation to Image. In the expression, select Images.

There is a set of default images, the led_* images are the generic circles. You can also load your own images, Loading Images into QlikView

Re: Using shapes in straight table

rahulpawarb — Thu, 14 Jun 2018 10:43:22 GMT

Please use below expression with Display Options set to Representation = Image & Image Formatting = Keep Aspect

If(Status='Red', 'Red.png', If(Status='Green', 'Green.png', 'Yellow.png'))

Hope this will help.

Regards!

Rahul Pawar

Re: Using shapes in straight table

dapostolopoylos — Thu, 14 Jun 2018 10:47:00 GMT

You could use an Expression set to be a Traffic Light Gauge based at conditions that you will define

Re: Using shapes in straight table

Anonymous — Thu, 14 Jun 2018 12:01:25 GMT

it worked ,thanks