topic Re: Calling straight table when clicked on a particular chart in QlikView

Calling straight table when clicked on a particular chart

rsdhavle — Thu, 07 Aug 2014 06:03:21 GMT

We have 4 straight table chart overlapped. The requirement is when i click on one particular bar chart, one of this table should populate.

I think there is no action feature in Bar charts. So is there any work around to do so?

Re: Calling straight table when clicked on a particular chart

Thu, 07 Aug 2014 06:10:09 GMT

Hi,

If you are selecting a dimension value in the chart, then you can use a variable which uses the dimension value and then use the Variable Event trigger in the document properties to show your Tables accordingly.

If you are just clicking anywhere else without selecting any dimension value, then you can use a Text box with transparency 100% on top of the graph and use its actions.

Re: Calling straight table when clicked on a particular chart

sujeetsingh — Thu, 07 Aug 2014 07:00:04 GMT

This is the one which uses variables and actions

Se the sample please

Re: Calling straight table when clicked on a particular chart

aveeeeeee7en — Thu, 07 Aug 2014 07:05:22 GMT

Yes, you are Right Bar Chart doesn't have Action feature.

But, you can achieve your desired Result using Conditional - Variables Show/Hide.

Set on Charts Layout.

It will work for you.

Regards

Aviral Nag

Re: Calling straight table when clicked on a particular chart

rsdhavle — Thu, 07 Aug 2014 07:06:59 GMT

Thanks for inputs..Can you please elaborate a bit on Variable Event trigger..Lets say i have one table object as TB02 and I have to call it from one dimension lets say 'A'..how can it be done?

Re: Calling straight table when clicked on a particular chart

Thu, 07 Aug 2014 12:38:19 GMT

Hi,

You can create a variable like dis.

vVar = getfieldselections(Dimension).

The in trigger you can check the Variable Event trigger - OnChange set another variable as 1 or 0 to show or hide the table you want.

Re: Calling straight table when clicked on a particular chart

sudeepkm — Thu, 07 Aug 2014 12:56:43 GMT

One of the simple way is to use layout conditional visibility in your st table. getSelectedCount(DimensionField)>0

when one or more than one values of the DimensionField is selected in the bar chart then the st table appears. you need to make sure the dimensionfield is not present on any other list box or other charts.

Please take a look at the attachment.