Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
adhudson
Contributor II

Waterfall Chart with negative values

Is there any way to develop a chart like shown below?

  • Dimension           – Year Month
  • Measure              – No of alerts generated by iComfort Devices.
  • Coloring               – Alerts generated by Current Month > Previous Month -> Green                                                                                    – Alerts generated by Current Month < Previous Month -> Red

Waterfall.jpg

Tags (1)
2 Replies
Luminary
Luminary

Re: Waterfall Chart with negative values

Hi! As the waterfall chart supports only measures, I guess you will have to create a measure for each month and assign custom colors, e.g. something like

January:

Measure: SUM({<Month={'January'}>}Alerts)

Custom color: GREEN()

February:

Measure: SUM({<Month={'February'}>}Alerts) - SUM({<Month={'January'}>}Alerts) to see if there is an increase or decrease

Custom color: IF(SUM({<Month={'February'}>}Alerts) - SUM({<Month={'January'}>}Alerts) > 0, GREEN(), RED())


March:

You got the drill.

Luminary
Luminary

Re: Waterfall Chart with negative values

So does this work for you?