Populate a straight table by clicking on the bars in bar chart

[ishika00730]

Hi All,

I have a requirement to populate a straight table by clicking on a bar in the bar chart. Can someone suggest how to do that?

Thanks in advance.

Regards

Ishika Gupta

[effinty2112]

Hi Ishika,

Clicking on a bar in a bar chart will select that bar's value in the dimension of the chart. That selection will also apply to a straight table in the application unless you are using an Alternative State for the table.

Cheers

Andrew

[ishika00730]

Hi Andrew,

Thank you for the reply but the requirement is that the straight table is conditional hidden and  will only populate when we click the bar in bar chart. Just want to know how to align the straight table such that it opens only on a clik on bar chart and also how to assign the action on the bar chart so that straight table appears

Thanks

Ishika

[ziadm]

This is the whole concept of Qlik associative data.  Any dimension click will filter the data based on the selected dimension.  No need to do extra work ..

[ziadm]

on the straight Table Properties --> Layout -->Show

add condition

if(NoOfRows() > 0 ,1,0)

[ishika00730]

I know that the selection will propagate through all the tables in my data model but the actual requirement is how do I show straight table by clicking on the bar chart. How to assign actions to the bar chart? The straight table will only appear when we click on a dimension bar in the bar chart

[Anonymous]

You would need to make your conditional show equation to only show the Straight table when 1 dimension is selected on the bar chart correct?

So conditional formula would be something like:

=GetSelectedCount(YourDimFromBarChart)=1

or if they can select more than 1 then

=GetSelectedCount(YourDimFromBarChart)>0

[vishsaggi · Accepted solution]

Check this attached.?

Use like in Straight table Layout tab

Conditional radio check

= IF(GetSelectedCount(yourbarchartFieldname) > 0 , 1, 0)

[qv_testing]

use this expression in straight table.

Layout-->Conditional

if(GetSelectedCount(YourBarchartDimension)>0,1,0)

[ziadm]

There is nothing in Qlik Triger on chart selection .. You can Trigger on Dimension selection ,, in your case if ID (Dimension ) is selected then populate the straight table.  That selection can be from anywhere clicked

= IF(GetFieldSelections(ID) > 0, 1, 0)