Discussion Board for collaboration on QlikView Scripting.
as Per your expression Guage chart is showing result
is 4 is it correct?
Data I have provided should give me 5.1 as result in guage
as per data it was showing result is 5
yes answer is 5
is it ok
Hi please find the attached file
Ceil do not give me perfect value
Profitability to be calculated as
(Sum of total profit) / (Sum of total Value)
as per data its giving the result like
if u want check in text object like :- =sum(TOTAL Profit)/sum( TOTAL value)
I got it
Sum(Profit)/Sum(Value) gave me the desired answer.
Thanks for the help.
Hi Vikas, if your answer is solved please mark correct/helpful answers to close the thread.