topic Re: Need to know how to create a variable from accross multiple files in QlikView

Need to know how to create a variable from accross multiple files

Thu, 02 Jun 2016 21:09:11 GMT

I am reading in multiple files with the same file layout, except for a created variable in each load statement.

I want to be able to add (sum) each of the created variables, which provides me with a combination variable (combo).

For example, the variables are var1, var2, var3, etc. Var1=1, Var2=10 and Var3=100. I want a variable that is a combination of 111. Combo = 111 or Combo = 101.... you get the idea.

Help. So the question is:

Do I calculate a new variable?

Do I develop and expression?

Do I use the “aggr” function?

I am new at this so I might need detailed instructions. I have attached a brief PowerPoint description of the desired outcome.

Thanks in advance.

Mark

Re: Need to know how to create a variable from accross multiple files

swuehl — Thu, 02 Jun 2016 22:40:45 GMT

I can't find the attachement.

Could you also post the current script you are using to load the files and variables?

I assume you should be able to use something like

Let vCombo = RangeSum(var1, var2, var3);

Re: Need to know how to create a variable from accross multiple files

Anonymous — Fri, 03 Jun 2016 07:09:52 GMT

Hi Mark,

I have seen that your tables are the same fields, why don't create the same field name with other values and combine it with group by?

Kind regards

Re: Need to know how to create a variable from accross multiple files

Fri, 03 Jun 2016 08:04:54 GMT

Hello,

if I got it right, it is about summing and grouping. Please find an approach attached.