Calculation Logic in bar chart

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

Guys,

I have this bar chart below,

These 3 customers in this chart can have common fields mutually.

Based on this chart, I need to create another bar chart and in that chart, customer which is having highest count needs to come first.

(i.e Maersk needs to come first as per the above chart)

From the other 2 customers, second highest customer, Cargosmart has all the 4 fields common to Maersk. So, it should not be displayed.

and Addivant has 1 field out of 3 fields which is not common to Maersk.

Finally I need 5 for Maersk and 1 for Addivant. Comparison should always be based on the customer which is having highest count.

Please help me out guys since it is really very complicated for me.

Thanks,

Siva.

topic Calculation Logic in bar chart in QlikView