Creating Traffic lights in Qliksense Table

[srishsum2017]

Creating Traffic lights in Qliksense Table-

I have some data of Sales and Product.

Step1- Select the Table from the charts

Step2- From the data select the Product Group as dimension and Expression like as to calculate Profit-

=(sum(Sales)-Sum(Cost))/Sum(Sales)

Step3- Change the properties of Measure as like below-

1. Lable- Profit
2. Number Formatting- Number
3. Formatting- Simple (12.34%)

This formatting will help you to show profit in %.

Step4-  Create another measure and insert the Unicode symbol for Black circle i.e. Chr(11044).

1. Create label as Traffic
2. In Text color expression put the below mentioned expression-

=if(((Sum(Sales)-Sum(Cost))/Sum(Sales))>0.6,lightgreen(),

if(((Sum(Sales)-Sum(Cost))/Sum(Sales))>0.4 and ((Sum(Sales)-Sum(Cost))/Sum(Sales))<0.6, Yellow(),

if(((Sum(Sales)-Sum(Cost))/Sum(Sales))<0.4, lightRed()

)

)

)

You will get result as-

[ingo_lsg]

How can we filter the traffic lights in the table?

[srishsum2017 · Accepted solution]

This is created by expression as conditional, so it is not possible to select direct from table. You have to create some flag for this and take that flag in filter pane to filter the traffic light.