topic Re: Drillthrough from table/pivot in QlikView

Drillthrough from table/pivot

imtiaz_ullah — Fri, 17 Apr 2015 12:11:55 GMT

Hi guys,

Does anyone know a way of drilling through (not dimension drill down) to the raw data behind a pivot table at a cell level?

I've seen ways to drill-through to another document from a different object, but not from within a table.

Thanks

Immy

Re: Drillthrough from table/pivot

Gysbert_Wassenaar — Fri, 17 Apr 2015 13:14:41 GMT

Perhaps like in the attached example.

Re: Drillthrough from table/pivot

imtiaz_ullah — Fri, 17 Apr 2015 13:44:44 GMT

Is this done just by displaying an additional table when =len(GetCurrentSelections()) ?

Re: Drillthrough from table/pivot

Gysbert_Wassenaar — Fri, 17 Apr 2015 13:50:16 GMT

Yes.

Re: Drillthrough from table/pivot

imtiaz_ullah — Fri, 17 Apr 2015 14:00:24 GMT

Thanks. What other settings do I need as it doesn't seem to work with just that condition. Is there something else I need to set as the box is always displayed.

Re: Drillthrough from table/pivot

imtiaz_ullah — Fri, 17 Apr 2015 14:06:30 GMT

OK, I've figured it out, but actually this doesn't seem to be the solution I am looking for.

The hidden table always shows when I click on any row, but that's not actually what I am looking to do.

I want to be able to have a Pivot table and then expand down to the most granular level. When I am there, I would like the raw hidden data to be displayed when I click on that row.

Thanks