Skip to main content

# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Search instead for
Did you mean:
Not applicable

## Vary data point color depending on condition in chart

I have a line chart. In one of the expressions I use symbols (Points) to represent it. I want each of these points (symbols) to be painted with one color or another depending on some conditions.

So I defined background color for the expression as below:

\$(target_orders)

which is a variable that I have defined as below:

if(\$(numOrders) < 10, Green(), If(\$(numOrders) >= 10 and \$(numOrders) <= 50, Yellow(), Red()))

and numOrders is another variable as below:

sum({\$<[Order Type] = {'A'}>}if([quantity] > 20000.0, 1,0))

What is happening is that all points are being painted with the same color and the correct would be (based on conditions) some red and some green.

Any ideas?

3 Replies
Partner - Champion III

I am not sure whether you should be setting the foreground or background colour.

Having tested that, test your logic by creating a straight table with the same dimension as your chart, and with the expressions:

=sum({\$<[Order Type] = {'A'}>}if([quantity] > 20000.0, 1,0))

=f(\$(numOrders) < 10, Green(), If(\$(numOrders) >= 10 and \$(numOrders) <= 50, 'Yellow', 'Red'))

The results of this table should give an insight into the problem.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner - Champion III

Another thought occurred to me - Are the expression defined with a leading = sign? If so, then they are expanded and evaluated before the chart is constructed and have no knowledge of the chart dimensions. Try removing the = sign so that they can be expanded and evaluated within the chart.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

I am not using = sign.

Community Browser