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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Federico2
Partner - Contributor
Partner - Contributor

Expresión pasada a Script

Buen día, soy nuevo en qlik y necesitaría pasar esta expresión que esta en un grafico a al script.

 

Count({< Prov_BRSCH={57,58,59,60,61,62,64} , P_ZTERM-={'FDC0'}>}P_BELNR)

*

SUM(
aggr(
(SUM({< Prov_BRSCH={57,58,59,60,61,62,64} , P_ZTERM-={'FDC0'}>}P_DMBTR)/Sum (TOTAL<P_BUKRS, Prov_BRSCH,MES_PROVEEDORES> P_DMBTR))
*
Interval(DATE(P_AUGDT, 'YYYYMMDD') - DATE#(P_BLDAT, 'YYYYMMDD'), 'D')

, P_BUKRS, Prov_BRSCH , P_XBLNR , MES_PROVEEDORES)
)
/

Count(TOTAL<Prov_BRTXT>{< Prov_BRSCH={57,58,59,60,61,62,64} , P_ZTERM-={'FDC0'}>}P_BELNR)

 

0 Replies