topic Re: how to sum and divide expressions with set analysis in QlikView

how to sum and divide expressions with set analysis

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

i have two expressions that i would like to add together and then divide by the total number to find a percent of automated orders how would i do this.

=num(sum(count({<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Pur. ord. type_BSARK_line]={'EDI','XML'}, [Order Document Type_AUART_line]-={'QT'},[Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line)

Count ({<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Order Document Type_AUART_line]={ZWEB}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line))

count({<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Pur. ord. type_BSARK_line]=, [Order Document Type_AUART_line]-={'QT'}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line),'##.##%')

this is my expression how can i fix it to work

Re: how to sum and divide expressions with set analysis

vishsaggi — Tue, 10 Apr 2018 17:49:37 GMT

Try this?

=Num(
Rangesum(count({<Source={'Billing'}, RejectionReason_ABGRU_line={' '}, [Pur. ord. type_BSARK_line]={'EDI','XML'}, [Order Document Type_AUART_line]-={'QT'},[Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line)
,
count({<Source={'Billing'}, RejectionReason_ABGRU_line={' '}, [Order Document Type_AUART_line]={ZWEB}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line))
/
count({<Source={'Billing'}, RejectionReason_ABGRU_line={' '}, [Pur. ord. type_BSARK_line]=, [Order Document Type_AUART_line]-={'QT'}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line)
,'##.##%')

Re: how to sum and divide expressions with set analysis

sasiparupudi1 — Tue, 10 Apr 2018 18:28:29 GMT

May be try

Num(

Count(

{

<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Pur. ord. type_BSARK_line]={'EDI','XML'}, [Order Document Type_AUART_line]-={'QT'},[Company Code_BUKRS]={'1100','1500'}>

<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Order Document Type_AUART_line]={'ZWEB'}, [Company Code_BUKRS]={'1100','1500'}>

}

distinct %OrderDocumentItem_Key_line

)

,'##.##%')