topic Waterfall chart in QlikView

Waterfall chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

I have the below bar chart. I need to create a waterfall chart based on the highest value (sort by descending order) as shown below,

Expected Chart: (by comparing the values from the above bar chart)

Calculation Logic:

1. As per the chart1, customer Cargosmart has the highest count(145) and Maersk has 80.

2. Both the customers have some fields in common. Field count shows the count as (126) 70% in the second chart (waterfall chart) and 18(10%) for Maersk out of the remaining 30% (because out of 80 fields in maersk 62 fields already matched in Cargosmart) and so on in descending order.

similarly for all customers until it reaches 100%.

Please help me to achieve this guys.

Note: The above mentioned two charts don't relate each other as per my logic. so please don't compare both.

Thanks,

Siva.

Re: Waterfall chart

sunny_talwar — Fri, 21 Jul 2017 18:53:18 GMT

Do you have a sample to share?

Re: Waterfall chart

Anonymous — Fri, 21 Jul 2017 19:09:17 GMT

Attached sample data and QVW. Please check it.

Re: Waterfall chart

sunny_talwar — Fri, 21 Jul 2017 19:13:18 GMT

So when Hapag Lloyd is selected, you want the second bar to start from 2 and third bar from 6?

Re: Waterfall chart

Anonymous — Fri, 21 Jul 2017 19:20:30 GMT

I need to get the maximum value and sort it by descendig order.

When Hapag Lloyd is selected, I want the third bar (Maersk) to show first from (0 to 5) in y-axis and then Cargosmart and then Addivant, but one condition it should not show the common fields between each other.

i,e 1. Maersk - 5

2. Cargosmart - 0 (because it has all the 4 values common in Maersk) and

3. Addivant - 0 (2 fields already common to Cargosmart)

I have to compare the common fields in this hierarchy- Maerk- Cargosmart - Addivant.

Re: Waterfall chart

Anonymous — Fri, 21 Jul 2017 19:44:16 GMT

Are you confused? Please see this attachment.

In this, for Addivant customer, the field "Goods" is only specific to it.

so, in waterfall chart, I want the count as below,

Maersk - 5 (First)

Addivant - 1 *Second) and

Cargosmart -0.

Re: Waterfall chart

sunny_talwar — Fri, 21 Jul 2017 19:48:11 GMT

Checking... I sort of understand the requirement, but the calculation is a little complex

Re: Waterfall chart

Anonymous — Fri, 21 Jul 2017 21:28:21 GMT

Sunny, got any idea on this?

Re: Waterfall chart

Anonymous — Sat, 22 Jul 2017 13:44:21 GMT

Sunny please respond if it is possible to do?