QlikView Bar chart

[Anonymous]

Guys,

I have a requirement like when I selected a bar in the bar chart, that data should be shown in a separate table hiding the bar chart and I have the below bar chart with the expression,

=Dual(Num(Count({<Customer_Name= E(Customer_Name),Destination_Format_Flag={'-1'},Mapping = P(Mapping),FieldName= P(FieldName)>}FieldName),'#,##0')&

' ('&if(num(Count({<Customer_Name= E(Customer_Name),Destination_Format_Flag={'-1'},Mapping = P(Mapping),FieldName= P(FieldName)>}FieldName)/vCount*100,'##.')>100,100,num(Count({<Customer_Name= E(Customer_Name),Destination_Format_Flag={'-1'},Mapping = P(Mapping),FieldName= P(FieldName)>}FieldName)/vCount*100,'##.'))&'%)',

Count({<Customer_Name= E(Customer_Name),Destination_Format_Flag={'-1'},Destination_Format_Flag={'-1'},Mapping = P(Mapping),FieldName= P(FieldName)>}FieldName))

Plz help me to achieve this guys, in the above bar chart when I select that blue bar (Maersk) 170 fields to be loaded in a table.

[CarlosAMonroy]

Hi Siva,

You can try the following:

In the bar chart use a conditional expression like this:

GetSelectedCount(Customer_Name)=0

Then, in the table use this:

GetSelectedCount(Customer_Name)=1

So When you do a selection in the bar chart, the chart gets hidden and the table shows up and viceversa when you clear the field selections.

Hope that helps,

Carlos M

[trdandamudi]

Please see the attached and modify accordingly...

[Sergey_Shuklin]

Hi, Siva!

Like this?