need help

[#1]

Hi I have a requirement like below

Country	STARTTIME	ENDTIME	SALES/ORDERS
SALES_US	06/24/14	06/24/14	100
ORDERS_US	06/24/14	06/24/14	200
SALES_UK	06/24/14	06/23/14	150
ORDERS_UK	06/23/14	06/24/14	250
SALES_IN	06/24/14	06/23/14	80
ORDERS_IN	06/24/14	06/24/14	120

output looks like below

Country	Sales	Orders	SalesStatus(If STARTTIME=ENDTIME I need to display Green Traffic light else red Red Traffic light)
US	100	200	(green color Traffic light)
UK	150	250	(red color)
IN	80	120	(redcolor)

same logic as for Order Status also.

Can any one help me out thanks in advance

[MarcoWedel]

Hi,

even if your thread is already answered, just another solution:

LOAD SubField(Country, '_', 2) as Country,
     SubField(Country, '_', 1) as Type,
     STARTTIME = ENDTIME as Status,
     [SALES/ORDERS]
FROM [http://community.qlik.com/thread/122988] (html, codepage is 1252, embedded labels, table is @1);

pivot table:

created like this:

'qmem://<bundled>/BuiltIn/led_'&If(Status,'g','r')&'.png'

hope this helps

regards

Marco