Qlik Community

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
manojkulkarni
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
jpenuliar
Valued Contributor III

Re: Sum(Field1*Field2)

Have you tried :

Field1 + Field2

awhitfield
Esteemed Contributor

Re: Sum(Field1*Field2)

Hi Yasser,

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

HTH

Andy

MVP
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)?

jpenuliar
Valued Contributor III

Re: Sum(Field1*Field2)

Someone's moved up the ranks!

Gratz!

manojkulkarni
Valued Contributor II

Re: Sum(Field1*Field2)

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

awhitfield
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 !

Community Browser