topic Drilldown using Set Analysis in QlikView

Drilldown using Set Analysis

Fri, 04 Dec 2009 07:50:29 GMT

I used set analysis to aggregate data on a straight table.

I have created 3 aggregated measures namely # of Files Received, # Files Loaded and % Files Loaded.

I would like to drilldown from the % Files Loaded column and display only the records that were not loaded.

Instead, I am getting all the records equal to the # of Files Received.

I am enclosing a sample app for your reference.

Appreciate any ideas.

Thank you.

Drilldown using Set Analysis

Fri, 04 Dec 2009 15:14:05 GMT

Hi Anthony,

see the modified example for an idea how it could work.

Good luck!

Rainer

Drilldown using Set Analysis

Fri, 04 Dec 2009 15:18:32 GMT

Hi all,

Rainer's solution works perfectly.

Here you are other solution using set analysis.

Best regards.

Drilldown using Set Analysis

Fri, 04 Dec 2009 21:14:24 GMT

Thanks Rainier and Miguel.

I am now able to display the records that are not loaded but faced another problem.

I need to display all data in the straight table if I have not filter on the Summary table's % Files Loaded column.

1. Is there a way to accomplish this with one table ie. Display files not loaded when % Files Loaded is selected and display all files when % Files Loaded is not selected ?

2. Or can we toggle between tables once the % Files Loaded is triggered or selected ? This will give an illusion to the user of having just one detail table.

Thanks again for your thoughts.

Drilldown using Set Analysis

Fri, 04 Dec 2009 21:37:25 GMT

Hi Anthony,

now we toggel between both tables.

Rainer

Drilldown using Set Analysis

Fri, 04 Dec 2009 22:09:23 GMT

Thanks Rainer.

One last question. Is there a way to render certain columns clickable and non-clickable ?

In the summary table, only the % Files Loaded should be clickable, the rest are non-clickable.

Thanks again.

Drilldown using Set Analysis

Mon, 07 Dec 2009 15:03:17 GMT

Hi Anthony,

so far I know unfortunately not.

Rainer