Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using shapes in straight table

Hi

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

4 Replies
jwjackso
Specialist III
Specialist III

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

builtin_image.PNG

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

rahulpawarb
Specialist III
Specialist III

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

dapostolopoylos
Creator III
Creator III

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

Capture.JPG

Father/Husband/BI Developer
Anonymous
Not applicable
Author

it worked ,thanks