topic Filtering dimension based on another table in QlikView

Filtering dimension based on another table

Wed, 17 Aug 2011 18:35:03 GMT

I want to limit the number of records I pick up from a table to build a trellis chart. The issue I am facing is how to select a limited number of records based on a the value of the dimension in another table.

I have to pick Dim1, Dim2 and Expression from Table1 while I want to display only those value of Dim1 that are available in another table Table2.

Is there a way to use a calculated dimension for this?

Filtering dimension based on another table

Wed, 17 Aug 2011 19:22:03 GMT

Hello,

Can you attach a sample please, that helps you to get a quick and correct answer.

Filtering dimension based on another table

Oleg_Troyansky — Wed, 17 Aug 2011 22:31:09 GMT

As long as the two tables with those dimensions are properly associated, you can limit one dimension by the values of another.

You can either use Calculated Dimensions, which can be quite heavy at times, or you can apply your filter in Set Analysis within your Expression. If your expression only produces results for a limited number of dimension values, then all other values will be disregarded automatically. My personal choice would be using a Set Analysis in the Expression, whenever possible.