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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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...!