Qlik Community

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

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

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