topic Re: set expression in QlikView

set expression

Fri, 10 Oct 2014 09:15:34 GMT

please help me convert the below into set expression

=sum(if(Month(today())=AMonth,(Automated)))

sum(if(Month(today())=AMonth,([Total Regression TCs])))

Regards,

Hitha Dhani

Fri, 10 Oct 2014 09:16:59 GMT

SUM({<AMonth = {'$(=Month(Today())))'}>}Automated)/SUM({<AMonth = {'$(=Month(Today())))'}>}[Total RegressionTCs])

Fri, 10 Oct 2014 09:28:10 GMT

thank u this worked.

jus had to remove one bracket )

=SUM({<AMonth = {'$(=Month(Today()))'}>}Automated)

SUM({<AMonth = {'$(=Month(Today()))'}>}[Total Regression TCs])