Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You can set a trigger for 'Onselectfield' for 'Attribute'(in your case) as 'Activate Sheet'
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
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