# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

#### Breathe easy -- you now have more time to plan your next steps with Qlik! QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information. Not applicable

## set expression

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

/

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

Regards,

Hitha Dhani

1 Solution

Accepted Solutions Not applicable

## Re: set expression

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

2 Replies Not applicable

## Re: set expression

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

## Re: set expression

thank u this worked.

jus had to remove one bracket )

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

/

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

Community Browser