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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to add aggr function in expression

Hi Guys, could you please help me to add aggr on this expression?

Only({<AR_OF_LUXEVENT_HIST.USR_PERHIS_ESTADO={'200'}>}AR_OF_LUXEVENT_HIST.USR_PE_FECMOD)-Only({<AR_OF_LUXEVENT_HIST.USR_PERHIS_ESTADO={'150'}>}AR_OF_LUXEVENT_HIST.USR_PE_FECMOD))*24

i tried with:

1)  aggr(((Only({<AR_OF_LUXEVENT_HIST.USR_PERHIS_ESTADO={'150'}>}AR_OF_LUXEVENT_HIST.USR_PE_FECMOD)-Only({<AR_OF_LUXEVENT_HIST.USR_PERHIS_ESTADO={'0'}>}AR_OF_LUXEVENT_HIST.USR_PE_FECMOD))*24),AR_OF_LUXEVENT_HIST.USR_PERHIS_NEGOCI)

2) (aggr((Only({<AR_OF_LUXEVENT_HIST.USR_PERHIS_ESTADO={'150'}>}AR_OF_LUXEVENT_HIST.USR_PE_FECMOD),AR_OF_LUXEVENT_HIST.USR_PERHIS_NEGOCI) - aggr(Only({<AR_OF_LUXEVENT_HIST.USR_PERHIS_ESTADO={'0'}>}AR_OF_LUXEVENT_HIST.USR_PE_FECMOD)),AR_OF_LUXEVENT_HIST.USR_PERHIS_NEGOCI)*24

thanks!

gerardo

Labels (1)
0 Replies