Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to divide two variables?

I want to divide to variables, this syntax is not working.

=Sum($(vSetYTD)Cnt/$(vSetPreviousYearYTD)Cnt))

Alex

3 Replies
Not applicable
Author

Hi Alex: what is Cnt in your formula?

Not applicable
Author

Its the column that I'm using. The parens where just in the wrong order. I needed to close the sum on the first expression. This works.

Sum($(vSetYTD)Cnt)-sum($(vSetPreviousYearYTD)Cnt)

Not applicable
Author

Great...!