topic Re: Create a new dimension in QlikView

Create a new dimension

samuel_brierley — Fri, 13 Jun 2014 07:48:56 GMT

Hi all this should be a quick one,

I have lots of data tables that have identical dimensions but are from different sources, is is possible to add into the load script for example "site1 as Source" or Site2 as Source" then i can filter on Source.

thanks

Re: Create a new dimension

tresB — Fri, 13 Jun 2014 07:59:39 GMT

I guess you meant flagging. Yes you can, like:

Load

'Site1' as Flag

From <Source1>;

Load

'Site2' as Flag

From <Source2>;

Now you get a single table(provided all the sources have same number of fields that are identical). Then you can filter accordingly using the Flag field.

Re: Create a new dimension

samuel_brierley — Fri, 13 Jun 2014 08:03:57 GMT

Thanks you