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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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?