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: 
Jaime_madrid
Contributor
Contributor

Resta de agregaciones

Cordial saludo,

Agradecería que me pudieran responder no me funciona esta operación, 

calculo un promedio mediante esta formula:

Count({<criterion_ID={2},Year={$(=Max(Year))}>} Flag_session)/$(vLastMonthInt)

Y calculo el promedio del año anterior:

count({<criterion_ID={2},Year={$(=Max(Year)-1)}>} Flag_session)/Count({<Year={$(=Max(Year)-1)}>}Distinct Month)

Ahora quiero restar ambos para ver cuando aumento en un KPI pero no me funciona, me muestra solo el primer resultado.

=Count({<criterion_ID={2},Year={$(=Max(Year))}>} Flag_session)/$(vLastMonthInt) - count({<criterion_ID={2},Year={$(=Max(Year)-1)}>} Flag_session)/Count({<Year={$(=Max(Year)-1)}>}Distinct Month)

2 Replies
IamAlbinAntony
Creator
Creator

Tente usar () para cada expressão. ou seja (Expressão 1) - (Expressão 2)
Jaime_madrid
Contributor
Contributor
Author

No funciona. ya lo intente