Discussion board where members can get started with Qlik Sense.
I want to create a dashboard in a semaphore/trafic light style.
My source data is:
Note: -1 is Red, 0 Yellow and 1 is Green
(ooxml, embedded labels, header is 2 lines, table is Milestones);
I want to build a dashboard, which would represent my status values in a trafic light, such like this:
Go to Solution.
In table, For Status Column , instead of using any image you can set background color to give colors to display it as Traffic light
See if attached will help you.
NoConcatenate EmpData: LOAD * FROM [..\Data\Test6.xlsx] (ooxml, embedded labels, table is Sheet1); Images: BUNDLE LOAD * INLINE [ ImageID, Path Red, ..\Data\Red.png Green, ..\Data\Green.png Yellow, ..\Data\Yellow.png ];
=If(Status=-1,'qmem://ImageID/Red', If(Status=0, 'qmem://ImageID/Yellow', If(Status=1, 'qmem://ImageID/Green')))
Thank you for your usefull response.