topic Trigger Cell pivot table in QlikView

Trigger Cell pivot table

emteam162 — Sat, 06 Oct 2012 21:52:45 GMT

Hi,

I created a simple table my idea is to select a value in a cell then display the table corresponds to the selection

Section	Status	Expression1	Expression2
HB	pending	12	3
HA	finished	4	1
HD	cancel	3	1
HC	pending	1	1

I click on cell (HD, Expression1) = 2

I should display this table :

ID	year	month
123	2012	1
124	2012	2
125	2012	3

Any idea or help

Many thanks.

Best Regards,

Emteam

Re: Trigger Cell pivot table

Gysbert_Wassenaar — Sun, 07 Oct 2012 13:03:16 GMT

You can't assign specfic actions to individual cells in a table. But you can use triggers on selections, so that making a selection triggers an action. See http://community.qlik.com/message/184454#184454 for more information.

Re: Trigger Cell pivot table

emteam162 — Sun, 07 Oct 2012 15:37:04 GMT

Hi,

Thank you for your reply my idea is when you make selection in cell you should see the detail about this selection in my example i click in value 3 in a cell i should display the detail of ID how has status CANCEL.

I don't know if i can do that with QlikView and my boss want this function

Many thanks

Best Regards,

Emteam