Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

Not applicable
Author

thank u this worked.

jus had to remove one bracket )

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

/

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