Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
mangukiyam
Contributor
Contributor

Set dynamic Waterfall Range

Hello guys,

I need your help with setting a dynamic range for the waterfall.

It should dynamic so, no need to change it every time.

mangukiyam_0-1662022788116.png

Any suggestions are welcome, Thank you 

Labels (3)
2 Replies
Mark_Little
Luminary
Luminary

Hi,

Depends on how you want to make it dynamically  change.

I tend to use If( Value 1 > Value 2, Value 2 8 * 0.95, Value 1 * 0.95)

williejacobs
Creator
Creator

Hi @mangukiyam 

Maybe try using a variable linked to a Variable Input from custom objects.

In your formula then as suggested by Mark use an If formula.