Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculation Logic in bar chart

Guys,

I have this bar chart below,

Screenshot_18.png

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.

0 Replies