0 Replies Latest reply: Jun 17, 2013 11:53 AM by Henrik Larkander RSS

    Combining two fields in one dimension

      Attached: Example.qvw, Example.xlsx


      Hello all!


      In the attached qvw-file (an example file analogous to the case propper), I need to create a variable to be used in a calculated dimension in a cyclic group.


      (The xlsx file will be updated with new data evry so often, so I'd rather stay away from hard coding anything into the script.)


      It needs to do the following:


      If a city is selected in Deo_list, it alone is used as dimension.


      If a group is selected, it is used as dimension, along with it's member cities


      Example 1: Select Coventry => Coventry   

      Example 2: Select London Metropolitan => London Metropolitan, Arsenal, Tottenham, and WestHam

      Example 3 UK area => London Met, Midlands CMA, North-West CMA, + all cities in the UK. I.e NOT Ireland and NOT Dublin


      Any ideas? Any help would be much appreciated!