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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Divide by 2 Variables

I have two variables.... They are both counts of certain criteria. I want to be able to write an expression to divide them. When I write it.... I get a blank line. I know my two variables are working correctly. I put them both in a KPI and the numbers populate.

I wrote my expression like so.... $(vCountPOScode1) / $(v%POScode1)

I'm not sure why this isn't working. Please advise.

40 Replies
ptwistp1
Contributor III
Contributor III

I am unsure if this will help anyone, but... it looks like everyone here is just over complicating everything.

What I do is just put the variable within parenthesis, for example, =($(variable 1)) / ($(variable 2)) then you need to change your format to "number", and make sure you select "%" as the second format.


Does this help at all?