cancel
Showing results for 
Search instead for 
Did you mean: 

Water fall Chart

Hitendra
Rocketeer

Is there any way to start Margin P1 from zero.Is there any way to start Margin P1 from zero.

3 REPLIES 3

michael_ross
Employee
Employee

Hi @Hitendra 

It is not possible to have a specific measure render from zero. Each new measure will add or subtract from the previous point in the waterfall. You can add a Column Grand Total from the Settings pane, which will render a total from zero.  

michael_ross_0-1654613283066.png

However, I am assuming based on the column names in your example that you are trying to do a period to period comparison where your last measure is more of a reference point for comparison, instead of a component of the waterfall.

One option you might consider exploring is the Incorta Component SDK. Here is a link to the knowledgebase article that describes the custom visualizations that can be created through that framework.

https://community.incorta.com/t5/dashboards-analytics/getting-started-with-the-incorta-component-sdk...

Here's an example of a Waterfall chart that could be deployed in that framework.

https://echarts.apache.org/examples/en/editor.html?c=bar-waterfall 

Hitendra
Rocketeer

I am working on PVM(Price volume Mix) bridge for that, I have to show current year margin P1 and previous year margin P2 in water fall chart. Because it's important to show the data in below one .Qlik .png

Hitendra
Rocketeer

In Qlik there is an option in Pill(Measure column like. amount, margin e.g.) call subtotal with the help of that, I can do it. But in Incorta I didn't find any. If any other way to to that pls suggest.

 

 QLIK1.png