topic QlikView Bar chart in QlikView

QlikView Bar chart

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

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.

Re: QlikView Bar chart

CarlosAMonroy — Fri, 12 May 2017 14:31:11 GMT

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

Re: QlikView Bar chart

trdandamudi — Fri, 12 May 2017 14:46:20 GMT

Please see the attached and modify accordingly...

Re: QlikView Bar chart

Sergey_Shuklin — Fri, 12 May 2017 14:48:38 GMT

Hi, Siva!

Like this?