1 Reply Latest reply: Sep 5, 2011 10:17 AM by Goran Korsgren RSS

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

    Maarten Van Damme

      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:

        1. How much does the a test called 'Kalium' actually cost, based on a configuration table holding prices with a specific time range validity.
        2. 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, ...

       

      ForumQlikview_SetAnalysis.png

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

      Any help is highly appriciated (as always )

       

      Kind regards,

      Maarten