# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

## Sum(Field1*Field2)

Hello to all!

I tried the expression in the title of my question, SUM(Field1*Field2) in a chart. But I got nithing as a result. is there any problem in my expression. If yes, how can I make it?

Thank you !

1 Solution

Accepted Solutions
Valued Contributor II

## Re: Sum(Field1*Field2)

Your expression right. One of the field has non-numeric value. Could you post sample data

8 Replies

## Re: Sum(Field1*Field2)

Hi,

Just try Field1 * Field2

Is it giving you any output??

Regards

Regards,
Prashant Sangle
Valued Contributor III

## Re: Sum(Field1*Field2)

Have you tried :

Field1 + Field2

Esteemed Contributor

## Re: Sum(Field1*Field2)

Hi Yasser,

Try (Sum(Field1)*(Sum(Field2))

HTH

Andy

MVP

## Re: Sum(Field1*Field2)

In principal, your expression is fine.

Have you checked that both fields have a numeric representation? You can't multiply and sum text values.

Can you give a small sample of the data you are using for Field1 and Field2 and how these fields are related?

What are other properties of your chart (dimensions)?

Valued Contributor III

## Re: Sum(Field1*Field2)

Someone's moved up the ranks!

Gratz!

Valued Contributor II

## Re: Sum(Field1*Field2)

Your expression right. One of the field has non-numeric value. Could you post sample data

Esteemed Contributor

## Re: Sum(Field1*Field2)

Cheers mate! Yesterday was a good one! Don't think it's going to last though, ha ha!

Not applicable

## Re: Sum(Field1*Field2)

Actually, my field 2 was containing a non numeric values. I had to work on my Data source to make the operation faisable.

Thanks to all of you !