Solved: Sum(Field1*Field2) - Qlik Community

Report Inappropriate Content · ‎2015-05-21

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 !

manojkulkarni · ‎2015-05-21

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

View solution in original post

PrashantSangle · ‎2015-05-21

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 · ‎2015-05-21

Have you tried :

Field1 + Field2

awhitfield · ‎2015-05-21

Hi Yasser,

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

HTH

Andy

swuehl · ‎2015-05-21

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 · ‎2015-05-21

Someone's moved up the ranks!

Gratz!

manojkulkarni · ‎2015-05-21

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

awhitfield · ‎2015-05-21

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

Report Inappropriate Content · ‎2015-05-21

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 !