Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

How to Color by?

Hello folks,

I have a distribution chart as follows:

  • Y Axis - Activity
  • X axis - Resolve %
  • Points - Cusomter

I wanted to color each of the data point in 2 colors using color by expression

For each activity (Y axis point), the mean has to be found and anything greater than mean is blue and anything less than mean is red.

How can I achieve this?

My color by expression is not auto resolve. It is as follows:

SUM({<$(vDateFilter),GreaterThanToday={0}>}IncidentCount)

So the color by expression should be something like:

IF(AVG(AGGR(SUM({<$(vDateFilter),GreaterThanToday={0}>}IncidentCount),Customer))

>

SUM({<$(vDateFilter),GreaterThanToday={0}>}IncidentCount)

,RED(),BLUE())

Untitled.png

Tags (1)
1 Reply
hacr-sds
Contributor

Re: How to Color by?

Can you attach an app to work with ?