06-07-2022 07:06 AM
06-07-2022 07:59 AM
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.
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.
Here's an example of a Waterfall chart that could be deployed in that framework.
06-08-2022 12:25 AM
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 .
06-08-2022 01:24 AM
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.