Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
|
UK | 150 | 250 |
|
IN | 80 | 120 |
|
same logic as for Order Status also.
Can any one help me out thanks in advance
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