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: 
adiarnon
Creator III
Creator III

Gauge Problem

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 -

unnamed12.png

someone know why its happening??

adi

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Can you provide sample Application to look over.

Regards

ASHFAQ

adiarnon
Creator III
Creator III
Author

hi,

im sorry but i cant,

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

mdmukramali
Specialist III
Specialist III

!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
Creator III
Creator III
Author

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