Setting a trigger on straight table expression columns

[#1]

Hi Guys,

I have requirement in one of my qlikview report.

I will have a straight table something like as shown below

My requirement is that when the user clicks on the table cells where % values(100%,25%..) are shown, another straight table should pops up.

In other words I would like another straight table chart to be displayed upon clicking in the table cells (% values)

I cannot set a trigger on straight table. Is there any way I Can set a trigger here?

I thought of placing an invisible text box over the table columns. But that wouldn’t help me as the number of rows in the straight table won’t be fixed. It would be growing.

Anybody worked on such requirements?

Any help would be greatly appreciated.

Thanks and Regards,

Praveena

[lironbaram]

hi just a thought

when a user clicks on a cell of expression he is selecting the values in the dimensions in the same row

so if you can have another table , that have conditional show that says getselectedcount(Dimension Field)=1

so only if there is on value in the dimension field the table will show

hope it helps you

[#3]

You can set a trigger for 'Onselectfield' for 'Attribute'(in your case) as 'Activate Sheet'

[#4]

Hi Liron,

Thanks for the reply.I tried this

Since the entire row gets selected when the user clicks on a table cell, I cannot add a particular condition in the conditional show.

Thanks and Regards,

Praveena

[#5]

Hi Liron,

Thanks for the reply.I tried this

Since the entire row gets selected when the user clicks on a table cell, I cannot add a particular condition in the conditional show.

Thanks and Regards,

Praveena