topic Re: How to create a percentage variable based on two other variables in QlikView

How to create a percentage variable based on two other variables

bashar_f — Thu, 17 Jul 2014 08:55:59 GMT

Hi,

I have 2 variables,

vApplicationsCount = Count(Apps)

vEnrolmentCount = Sum(Enrol_Status)

so basically in the end they are two numbers.

I need to create a new variable that is equal to the percentage of enrolments over applications?

% of Enr/Apps

What would the definition be?

Re: How to create a percentage variable based on two other variables

alexandros17 — Thu, 17 Jul 2014 08:59:30 GMT

You can do:

vNewVar = Count(Apps)/Sum(Enrol_Status)

vNewVar = $(vApplicationsCount) / $(vEnrolmentCount )

Re: How to create a percentage variable based on two other variables

SergeyMak — Thu, 17 Jul 2014 09:03:29 GMT

Just because of percentage

vNewVar = NUM($(vApplicationsCount) / $(vEnrolmentCount ), '#,##0%' ) Or you can use formatting from Number tab in you chart.

Re: How to create a percentage variable based on two other variables

bashar_f — Thu, 17 Jul 2014 09:08:26 GMT

In the definition of the new variable, it recognizes when I type vApplicationsCount, is it really necessary to put the dollar sign here? Cant I just put the definition like this?

vApplicationsCount / vEnrolmentCount

NUM(vApplicationsCount / vEnrolmentCount , '#,##0%' )

Re: How to create a percentage variable based on two other variables

SergeyMak — Thu, 17 Jul 2014 09:13:58 GMT

It depends on your goal.

I usually use $-format

In case of vApplicationsCount you pass only text into the new variable. As I understand it will equal set vApplicationsCount='your text'

Re: How to create a percentage variable based on two other variables

bashar_f — Thu, 17 Jul 2014 09:16:41 GMT

I understand, Thank you very much.