Drilldown issue between two tables..Please help

Wed, 02 Mar 2011 13:57:26 GMT

Hello,

I have a drilldown scenario from one table to another one.

For example, I have the following fields in a table named Databases


Run_Date
,Category
,DBname
,Used_space

I have another table with below fields


Run_Date
,DBname
,TableName
,Used_Space

I have a drilldown group that has below directions

Category-->Databases(Same table)-->tables(Another table). I actuallly have a graph, where i show (Category/Database/Table) and same expression (Sum(Used_Space)) for all of these

I want to use only one measure Sum(Used_Space), so that no matter where am i in the drilldown group, the correct used space is calculated.

Now i want that the two tables be connected by Run_Date and DBname. I dont want them to have any links between used_space field. I cannot rename this field since this is the measure i will use in my expression. Since only one name can be used for all the drilldown group, therefore i cannot rename this field in either tables. but still i do not want that these tables have any link

Is it possible to use the same fields in both tables but still no link. or if it is not possible, then is there any alternative way?

-br

Arif

Drilldown issue between two tables..Please help

Wed, 02 Mar 2011 19:35:30 GMT

It looks like all the data is contained in your second table, except for Category. Assuming the Category does not change over time, you could load your entire second table, and the distinct values of DBname and Category from the first table, thereby linking the two tables only by DBname.

topic Drilldown issue between two tables..Please help in QlikView

Drilldown issue between two tables..Please help

Drilldown issue between two tables..Please help