Gauge Problem

[adiarnon]

hi,

i have a problem

i have a Gauge with just an expression

the expression should give -34

in the labal i see the 34(right)

but the number under 35

like in the picture -

someone know why its happening??

adi

[ashfaq_haseeb]

Hi,

Can you provide sample Application to look over.

Regards

ASHFAQ

[adiarnon]

hi,

im sorry but i cant,

i dont have internet in the computer with the qlikview...

[mdmukramali]

!Dear,

May be your using floor function. instead of floor use the ceil function.

Kindly find the attached sample file.

i Hope it will help you.

Thanks,

Mukram

[adiarnon]

hi,

om not using floor or ceil

=count({<PROJECT=>}if((aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula)),PROJECT)>0)
and (Aggr((Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}BudgetCurrentBook_$(vFinanceFormula)))/(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula))),PROJECT)=0),PROJECT))