If conditions

[#1]

Hi All,

I have a table as below.

Name	Type	Amount	Gain%
A	AA	Address1	b
B	BB	address2
C	AA	address3

I need to write a condition for Gain % in a Straight Table (Expression).

pls find the excel condition given below. I need to write the below expression in Qlikview.

b = IF ( OR(address1= "", sum(address1:address3)=0),"", (address1*100)/(address1:address3)

Can anyone help me with this ?

Thanks,

Praveen

[#2]

I dont have a column called Total amount.

I need to sum all the amounts.

[jpenuliar]

Total in this case is a Reserved word atatched to Sum() function. without it, the resulting values are per rows

[jpenuliar]

from Qlikview F1( help)

If the word total occurs before an expression, the calculation will be made over all possible values given the current selections, but disregarding the chart dimensions.

[jpenuliar]

if you try it now on qlikview, notice that "Total" is in blue color which means it is a reserved word