Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am new to Qlik sense, I have a simple question
Chart Type: Treemap
Dimension:
=IF(
Date([Timeline_Forecasts.Forecast Practical Completion]) - Date([Timeline_Forecasts.Baseline PC Date])>28,
'Delayed > 4 weeks',
IF(
Date([Timeline_Forecasts.Forecast Practical Completion]) - Date([Timeline_Forecasts.Baseline PC Date])>7,
'Delayed between 1 and 4 weeks',
IF(
Date([Timeline_Forecasts.Forecast Practical Completion]) - Date([Timeline_Forecasts.Baseline PC Date])>-7,
'Projects Delivered On Time',
'Projects Delivered Early'
)
)
)
Measure:
= SUM(
IF(
MATCH([Server.Stage],'Start Up', 'Delivery','Closed','Delivery-Closure', 'DLP','Support')
AND MATCH([Server.Portfolio], 'Domestic Precinct','International Precinct','Landside Infrastructure' ,'CAD & Spatial Services', 'Aeronautical', 'Commercial','Major Projects'),
[POIMS_Finance.Forecast Final Cost]))
I am trying to use the same dimension expression for Color by Expression, however, does not seem to work.
=IF(
Date([Timeline_Forecasts.Forecast Practical Completion]) - Date([Timeline_Forecasts.Baseline PC Date])>28,
'#D5331E',
IF(
Date([Timeline_Forecasts.Forecast Practical Completion]) - Date([Timeline_Forecasts.Baseline PC Date])>7,
'#FF9900',
IF(
Date([Timeline_Forecasts.Forecast Practical Completion]) - Date([Timeline_Forecasts.Baseline PC Date])>-7,
'#71B238',
'#4885ed'
)
)
)
The color expression does not work and last color (through else expression is chosen. Would appreciate support.
Thanks
Shoaib
Try if condition in script , also if you can define color in script itself and can use that field in color expression
As the expressions are the same, can't you just use Color by dimension?
Thanks. However, I cannot change the load script. Hence, I am trying out my options with the front end.
I have tried color by dimension as well. However I am not able to use custom colors. Would appreciate your help.