topic Need Suggestion.. in QlikView https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656844#M1065355 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have Dashboard, suppose i have a BAR char, customer wise data,</P><P>when i am click any particular Customer bar i want show details report in Straight table or pivot table...</P><P></P><P>please give me suggestions, how present data.....</P></BODY></HTML> Tue, 09 Sep 2014 13:23:36 GMT paulwalker 2014-09-09T13:23:36Z Need Suggestion.. https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656844#M1065355 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have Dashboard, suppose i have a BAR char, customer wise data,</P><P>when i am click any particular Customer bar i want show details report in Straight table or pivot table...</P><P></P><P>please give me suggestions, how present data.....</P></BODY></HTML> Tue, 09 Sep 2014 13:23:36 GMT https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656844#M1065355 paulwalker 2014-09-09T13:23:36Z Re: Need Suggestion.. https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656845#M1065356 <HTML><HEAD></HEAD><BODY><P>Create the straight table. When you click on a bar in the bar chart the straight table will be filtered automatically too. If you don't want to show the straight table if no customer is selected then enable the option Conditional on the Layout tab of the properties window and enter an expression =getselectedcount(<EM>CustomerIDFieldHere</EM>). Replace CustomerIDFieldHere with the name of your customer field.</P></BODY></HTML> Tue, 09 Sep 2014 13:33:36 GMT https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656845#M1065356 Gysbert_Wassenaar 2014-09-09T13:33:36Z Re: Need Suggestion.. https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656846#M1065357 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table or Pivot Table as per your requirements and go to Layout tab</P><P>Conditional Show</P><P>GetSelectedCount(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Customer</SPAN>)&gt;0</P><P></P><P>Now this table will only visible one you have at least one customer selected... How this help.</P></BODY></HTML> Tue, 09 Sep 2014 13:35:58 GMT https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656846#M1065357 MK_QSL 2014-09-09T13:35:58Z Re: Need Suggestion.. https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656847#M1065358 <HTML><HEAD></HEAD><BODY><P>You can either set up your straight table (as a separate object, not in a container_box) with a visibility_condition and place it in the same position as your bar_chart and set the barchart with the opposite visibility_condition so when someone clicks on a bar (which you can find out with GETFIELDSELECTIONS()) the barchart will disappear and the details_table will appear - in that case, don't forget to implement sth. like a "Back" button to revert it ...</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Tue, 09 Sep 2014 13:37:31 GMT https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656847#M1065358 datanibbler 2014-09-09T13:37:31Z Re: Re: Need Suggestion.. https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656848#M1065359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have done something, please check once..</P><P>i have BAR chart when i am click any bar i need to display detail report...</P><P>i have created one variable(<STRONG>vShow</STRONG>) and Close button,</P><P></P><P>when i am click close button i need to close Detail report.....</P></BODY></HTML> Tue, 09 Sep 2014 16:43:48 GMT https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656848#M1065359 paulwalker 2014-09-09T16:43:48Z Re: Re: Re: Need Suggestion.. https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656849#M1065360 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Tue, 09 Sep 2014 16:53:23 GMT https://community.qlik.com/t5/QlikView/Need-Suggestion/m-p/656849#M1065360 Gysbert_Wassenaar 2014-09-09T16:53:23Z