4 Replies Latest reply: Dec 2, 2016 7:32 AM by Hans de Vries RSS

    Master Calendar to be linked to several unrelated tables

    Hans de Vries

      Management of the firm I'm working for has asked me to build a Management KPI dashboard, in which a number of tables should be loaded, part from Excel, part from QVD. These tables have no definite factual relationship. All have two datefields in common, Year and Quarter. They want to control ALL tables at once from two list boxes which - you guessed it - contains both Year and Quarter.

       

      Of course this could be done through variables and buttons to change values of the latter, in combination with set analysis, but I think this is a visually rather unelegant solution..

       

      Any suggestions on how to fix this? Use a Master Calendar with only Quarter en Year values? Or are variables the only way to go?

       

      Here is the data model. As you can see, totally unrelated...