Search within dimension data, based on fact data // Set analysis

Mon, 05 Sep 2011 13:45:11 GMT

Hello,

To illustrate my question, I've created a small QV file and a image.

I hope both are clear... if not, do not hesitate to ask me further details.

In short, there are two questions:

How much does the a test called 'Kalium' actually cost, based on a configuration table holding prices with a specific time range validity.
How much does the a test called 'Kalium' actually cost FOR ALL THE TESTS (table results), based on a configuration table holding prices with a specific time range validity. ==> So this last question will be a sum of tests which cost X, a sum of all tests which cost Y, ...

I've made some set analysis trials, but I can't get it work...

Any help is highly appriciated (as always )

Kind regards,

Maarten

gandalfgray — Mon, 05 Sep 2011 14:17:08 GMT

I had a look but I don't understand your datamodel as provided in your qvw.

According to your point 2. a Propertys(Kalium/Natrium) price depends on the date,

so I would assume there would be a direct link between Property and Tariff,

but in your model it goes thru a couple of other tables.

Why is that?

topic Search within dimension data, based on fact data // Set analysis in QlikView