Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a data modell like this:
direction values here: in or out
amount: values here numbers
date: values here ...
I would like to make an accumulated line chart (succeeded) which represents the incomes and expenses, and colored the two line with an expression (not succeeded).
Color and legend / Colors by expression: if(direction='in',lightred(),lightgreen()).
Please help me how can I set up the colors with expression for the lines.
qvf, pic and data are attached.
I think in there case Year was one of the dimensions whereas in your case direction is not one of the dimensions..... I tried with two dimension and a single expression, but the charts don't match. But check it out for urself if it makes sense to use this
it is bad that Sense doesn't use the logic what View has (color option in each expression) but thanks Sunny for your effort.
I will keep open the post maybe somebody has another suggestion...