topic adding values in 2 dimensions in qlikview in QlikView

adding values in 2 dimensions in qlikview

Anonymous — Fri, 22 Jun 2012 20:47:44 GMT

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

Thanx for your help.

Re: adding values in 2 dimensions in qlikview

swuehl — Sat, 23 Jun 2012 14:31:04 GMT

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).

Regards,

Stefan

Re: adding values in 2 dimensions in qlikview

Anonymous — Sat, 23 Jun 2012 15:16:28 GMT

Thats exactly what i did. =dimension1 +dimension2 but it gave error in calculation...

the 2 dimensions are in the same table side by side...I'll follow ur advice and post a sample qvw