Drill-down from a Pivot Table

[krishna_2644]

Hi Qlikers,

Is there any way in a pivot table where I can drill down to the data from each expression column  i.e the pivot table should act as if each of its field value is a drill down link to its related data.

Example:

When i click '128' i need to see 128 requests/details in some other table for period 2015-Aug.(i was able to achieve this).

Again when i click on 123, it deselects the period and gives me all the shipped/details from all the periods instead of giving me the shipped/details from the period 2015-Aug.

I've searched a lot in the community but couldn't find a proper solution for this.

Hoping for a solution.

I appreciate your time.

Thanks

[krishna_2644]

Hi Jagan,

Thanks a lot for the effort and the reply.

I have made some comments in your qvw for what the current scenario is and what i actually need.

Please see attached.

[krishna_2644 · Accepted solution]

Hello everyone,

Finally i found the solution with help of Qlik Support.

They have provided some triggers and with those triggers i generated an isolated table with the aggregated data and used that in the pivot table hence making the pivot static drill down.

See attached.

Thanks everyone for your responses.

Happy Qliking.