I have 2 dimensions and would like to add values from both columns to create a third dimension. I tried using 'add calculated dimension' but the result is always error. Can somebody show me the formula to calculate this? its basically ----- dimension1 + dimension2 = dimension3
Are the values of dimension1 resp. dimension2 numericals? I think a calculated dimension using something like
=dimension1 + dimension2
should work if you want to add up numericals or
=dimension1 & dimension2
if you want to concatenate (like attaching a string value to another).
But the resulting lines will depend also on your data model (two fields located in one table or maybe in two unlinked tables etc.)
If you still run into errors, it might be helpful if you could create and post a small sample QlikView file (you can attach files in advanced editor, follow the link in the upper right corner in the forum editor).
