Discussion Board for collaboration on QlikView Scripting.
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 !
Go to Solution.
Your expression right. One of the field has non-numeric value. Could you post sample data
Just try Field1 * Field2
Is it giving you any output??
Have you tried :
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)?
Someone's moved up the ranks!
Cheers mate! Yesterday was a good one! Don't think it's going to last though, ha ha!
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 !