How to change dimension dynamically

[Anonymous]

Hi all,

I have a requirement like, if a customer is selected in the filter as shown below,

it will compare the fields of that selected customer(Hapag Lloyd) with the fields of other two customers and find the matched fields as shown below,

In this chart, "Maersk" customer has 6 fields totally. Out of 6 fields, 5 fields exactly matched with the fields of the selected customer "Hapag Lloyd" and

similarly for "Cargosmart", it has 4 fields totally. Out of 4 fields, all the 4 fields exactly matched with the fields of the selected customer "Hapag Lloyd" and

I have used P() and E() functions in expression to achieve this. On clicking on the bars in that bar chart, I want to get the field details in a table.

=Count(DISTINCT{<comparison={'true'},Customer=E(Customer)>}FieldName)

For example, if I select that 5 fields of "Maersk" customer, that 5 fields alone should be displayed in a table and similarly for all the bars in that bar chart.

I tried but couldn't achieve this, because I've already used the customer dimension in the expression using P() and E() function. So, for example if "Maersk" is selected in the chart, the other two customers are displayed as I have used customer as a dimension in the bar chart.

Friends, Please give any other way to achieve this. It will be more helpful if I get any idea on this.

Thanks,

Siva.

[balabhaskarqlik]

A small try from my side:

If(Customer <> 'Hapag Lloyd', aggr(if(rank(count({<Field_Count = {"1"}>}Cargosmart))<=10,Customer),Customer))

View by= different customers

If(Customer <> 'Hapag Lloyd', aggr(if(rank(count({<Field_Count = {"1"}>} Maersk))<=10,Customer),Customer))

[Anonymous]

Can you explain how this expression works. I couldn't understand how it would be suitable for my scenario.

Thanks,

Siva.