topic Re: Divide one expression by another expression in QlikView

Divide one expression by another expression

justcotto — Wed, 25 Nov 2020 16:16:04 GMT

I have two expressions:

count({<RECORD_TYPE={'HIRE'}>} BUSINESS_UNIT)

and

count({<RECORD_TYPE={'HEAD_COUNT'}>} BUSINESS_UNIT)

I want to divide the number of people hired by the head count and put this into a chart. How can I achieve this?

Re: Divide one expression by another expression

Anil_Babu_Samineni — Sat, 28 Oct 2017 00:45:31 GMT

Do like this

count({<RECORD_TYPE={'HIRE'}>} BUSINESS_UNIT)

count({<RECORD_TYPE={'HEAD_COUNT'}>} BUSINESS_UNIT)

Re: Divide one expression by another expression

vishsaggi — Sat, 28 Oct 2017 00:46:42 GMT

May be this?

= count({<RECORD_TYPE={'HIRE'}>} BUSINESS_UNIT)/count(TOTAL {<RECORD_TYPE={'HEAD_COUNT'}>} BUSINESS_UNIT)

Re: Divide one expression by another expression

its_anandrjs — Sat, 28 Oct 2017 04:36:48 GMT

What out put you need can you share some sample here.

Re: Divide one expression by another expression

justcotto — Sat, 28 Oct 2017 18:06:05 GMT

Thank you but how do I get the expression to print out as a percentage?

Re: Divide one expression by another expression

its_anandrjs — Sat, 28 Oct 2017 18:46:23 GMT

You can try this way for percentage display

NUM((count({<RECORD_TYPE={'HIRE'}>} BUSINESS_UNIT)

count(TOTAL {<RECORD_TYPE={'HEAD_COUNT'}>} BUSINESS_UNIT)),'#,##0%')

NUM((count({<RECORD_TYPE={'HIRE'}>} BUSINESS_UNIT)

count( {<RECORD_TYPE={'HEAD_COUNT'}>} BUSINESS_UNIT)),'#,##0%')

Re: Divide one expression by another expression

vishsaggi — Sat, 28 Oct 2017 21:26:59 GMT

Use the Num() function as mentioned by Anand. Or you can use Number format from the Number tab of your chart properties. Like.

Re: Divide one expression by another expression

rwunderlich — Sun, 29 Oct 2017 00:43:31 GMT

To get the value to display as a percentage, you can use the Number format pane to format as Pct. Alternatively (like when you don't have a Number dialog) you can wrap the expression in a num() function to format.

num(

count({<RECORD_TYPE={'HIRE'}>} BUSINESS_UNIT)

/ count(TOTAL {<RECORD_TYPE={'HEAD_COUNT'}>} BUSINESS_UNIT)

,'0.0%')

The num() function supplies a format pattern describing how the value should be formatted for display.

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/conventions-number-time-formats.htm‌

-Rob

http://masterssummit.com

http://qlikviewcookbook.com