topic Dimensions in QlikView https://community.qlik.com/t5/QlikView/Dimensions/m-p/433734#M161667 <HTML><HEAD></HEAD><BODY><P>Within my current product I have Localities which can drill into teams, for example, North, South, West Localities that can drill into team 1, team 2, team 3 for each locality.&nbsp; What i'm after is creating a top level TRUST dimension. Is this possible?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 24 Sep 2012 10:49:13 GMT 2012-09-24T10:49:13Z Dimensions https://community.qlik.com/t5/QlikView/Dimensions/m-p/433734#M161667 <HTML><HEAD></HEAD><BODY><P>Within my current product I have Localities which can drill into teams, for example, North, South, West Localities that can drill into team 1, team 2, team 3 for each locality.&nbsp; What i'm after is creating a top level TRUST dimension. Is this possible?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 24 Sep 2012 10:49:13 GMT https://community.qlik.com/t5/QlikView/Dimensions/m-p/433734#M161667 2012-09-24T10:49:13Z Re: Dimensions https://community.qlik.com/t5/QlikView/Dimensions/m-p/433735#M161668 <HTML><HEAD></HEAD><BODY><P>Hi Kevin,</P><P></P><P>Do you mean a "TRUST" value in a new field for all possible localities? If so, yes, just add a new line to your LOAD script:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13484844620529201" jivemacro_uid="_13484844620529201"><P>LOAD Locality,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Team,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "Top Level" AS Trust</P><P>...</P><P>FROM ...</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 24 Sep 2012 11:01:47 GMT https://community.qlik.com/t5/QlikView/Dimensions/m-p/433735#M161668 Miguel_Angel_Baeyens 2012-09-24T11:01:47Z