topic Re: Sum(Field1*Field2) in QlikView

Sum(Field1*Field2)

Thu, 21 May 2015 08:58:56 GMT

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 !

Re: Sum(Field1*Field2)

PrashantSangle — Thu, 21 May 2015 09:07:44 GMT

Hi,

Just try Field1 * Field2

Is it giving you any output??

Regards

Re: Sum(Field1*Field2)

jpenuliar — Thu, 21 May 2015 09:09:42 GMT

Have you tried :

Field1 + Field2

Re: Sum(Field1*Field2)

awhitfield — Thu, 21 May 2015 09:10:32 GMT

Hi Yasser,

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

HTH

Andy

Re: Sum(Field1*Field2)

swuehl — Thu, 21 May 2015 09:11:19 GMT

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

Re: Sum(Field1*Field2)

jpenuliar — Thu, 21 May 2015 09:14:50 GMT

Someone's moved up the ranks!

Gratz!

Re: Sum(Field1*Field2)

manojkulkarni — Thu, 21 May 2015 09:25:15 GMT

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

Re: Sum(Field1*Field2)

awhitfield — Thu, 21 May 2015 09:46:59 GMT

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

Re: Sum(Field1*Field2)

Thu, 21 May 2015 09:49:44 GMT

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 !