Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

8 Replies
PrashantSangle

Hi,

Just try Field1 * Field2

Is it giving you any output??

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
jpenuliar
Partner - Specialist III
Partner - Specialist III

Have you tried :

Field1 + Field2

awhitfield
Partner - Champion
Partner - Champion

Hi Yasser,

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

HTH

Andy

swuehl
MVP
MVP

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
Partner - Specialist III
Partner - Specialist III

Someone's moved up the ranks!

Gratz!

manojkulkarni
Partner - Specialist II
Partner - Specialist II

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

awhitfield
Partner - Champion
Partner - Champion

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

Not applicable
Author

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 !