topic Re: Gauge Problem in QlikView

Gauge Problem

adiarnon — Sun, 12 Oct 2014 06:11:06 GMT

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

Re: Gauge Problem

ashfaq_haseeb — Sun, 12 Oct 2014 06:24:33 GMT

Hi,

Can you provide sample Application to look over.

Regards

ASHFAQ

Re: Gauge Problem

adiarnon — Sun, 12 Oct 2014 06:28:20 GMT

hi,

im sorry but i cant,

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

Re: Gauge Problem

mdmukramali — Sun, 12 Oct 2014 06:39:24 GMT

!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

Re: Gauge Problem

adiarnon — Sun, 12 Oct 2014 06:46:29 GMT

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))