Colored conditional line-charts in dimensions with high number of categories
It is well explained by Steve Street on color by expression - QlikSense, and Kaan Erisen in Change color in charts with conditional dimensions and aggregations how to create conditional colored line charts. Nevertheless, this option is perfect to be applied on Line Charts cases were you have few-categories dimensions (e.g. Sales Sum by Continent), as this solution uses the function ValueList and each category of a dimension should be entered manually. In the case of many-categories dimensions (e.g. Sales Sum by City_ID or Customer_ID) it does not work well, as it is not practical to enter manually the ID´s of all the cities.
My question is: is it possible to create this condition-colored Line Charts over many-categories dimensions without entering them manually with the ValueList approach?
I explain a reproducible file example attached:
Variable extensions values in the app attached:
BeginPromoA = 01.05.17
EndPromoA = 03.05.17
BeginPromoB = 04.05.17
EndPromoB = 06.05.17
BeginPromoC = 07.05.17
EndPromoC = 08.05.17
First I create a conditional colored line chart for an example where I only have 4 categories. It works well: