Gradient fill stacked bar chart where Dimension is Day of month
I have been asked to mimic and existing report for a new customer.
I'm documenting the solution I used here but i'm interested in Qlik experts critique and also enhancements.
I'm working from test data at the moment.
The issue is that they have a series of services (each bar) and they want to see how much each service is being used per day in a given month.
The bar chart is fairly simple, the dimensions are
A) the service (fleet 1..n)
B) the date field from the calendar
the expression (%JOIN_CALENDAR)
c) Count (Distinct workitems)
The issue is that the default colours loop after 15.
The clients corporate colours re white, blue and orange, so i used colour picker to get the # hex for their blue and orange and put it into a colour gradient generator to make a nice colour gradient with 31 steps.
I copied the data across into excel and used the formula =HEX2DEC(MID(C1,1,2)) to split it, and then used
="SET v_Colour_"&A1&" = 'RGB(" & E1& ", " & F1&", "&G1&")';" to automate the variables.
SET v_Colour_1 = 'RGB(50, 76, 124)';
I placed the variables in the load script, looking at it now i should have been let not set?
in the expression i set the background colour as follows,