Using Set Analysis with two different data sets (Ad-Hoc reporting)

Thu, 26 Jul 2012 17:45:02 GMT

I have created a table object that is very identical to the Ah-Hoc reporting example found in the QlikView 11 demo, except I changed the dimensions to “group, region, state, county, and township.” All townships are assigned a group number. One of the expressions that I would like to create is figuring out the number of people that my company served for a specific area in the country. The problem that I have encountered is the data that I am working with is in two different database tables. The flag to determine which database to use is by group #. I am currently using a nested IF statement in the expression and it works perfectly fine if I show ‘township’ or ‘group’ as one of the dimensions.

IF( Group = ‘1’,

**execute set analysis for Database #1**,

IF( Group = ‘2’,

**execute set analysis for Database #2**,

NULL))

However, if I deselect ‘township’ or ‘group’ as a dimension and only show the other dimensions, the rows cannot determine which group # to use and the table shows only null values. Would denormalizing all of the dimensions into one table fix this issue?

topic Using Set Analysis with two different data sets (Ad-Hoc reporting) in QlikView

Using Set Analysis with two different data sets (Ad-Hoc reporting)