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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Pablo_Vidal_1987
Contributor II
Contributor II

SUM not working in KPI

hi everyone,

i have a problem with a formula for a KPI, because is not showing the SUM:

if(sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) = 0 and
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) > 0,
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV)-
sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV),0)/1000000

i don´t know what i´m doing wrong, because this same formula works fine in a table:

Pablo_Vidal_1987_0-1652797720378.png

PLEASE HELP,

thank you. 

 

 

 

Labels (2)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Try below

 

SUM( AGGR(  if(sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) = 0 and
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) > 0,
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV)-
sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV),0)

, RUT) )

 

RUT <-- aggregate by your table dimension

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Try below

 

SUM( AGGR(  if(sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) = 0 and
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) > 0,
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV)-
sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV),0)

, RUT) )

 

RUT <-- aggregate by your table dimension

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Pablo_Vidal_1987
Contributor II
Contributor II
Author

Thanks a lot mate, works perfectly