topic Re: hi need urgent reply in QlikView

hi need urgent reply

Tue, 07 May 2013 05:46:34 GMT

hi ...can any one help me this issue...

I have a metric "AHOT Minute" and now i need to disply this in expression section of chart properties for that i used below defination to get AHOT Minutes,

sum(AHOT_MINUTES

)

So for this getting value like below

AHOT Minutes

50,701,420.40

But i want to disply AHOT minutes in the form of Days or Months.....is it possible to get like that ....?

Re: hi need urgent reply

Gysbert_Wassenaar — Tue, 07 May 2013 05:49:05 GMT

sum(AHOT_MINUTES)/1440 will give you the number of days. Divide it again by 30 and you approximately have the number of months

Re: hi need urgent reply

sushil353 — Tue, 07 May 2013 05:51:39 GMT

if you divide the above fig by (24*60) you will get days and further if you divide it by (30*24*60) then you will get month.

is it what you are looking for...?

Regards

Sushil

Re: hi need urgent reply

Tue, 07 May 2013 07:07:16 GMT

Yeah thanks for that rply ...now i am getting result like this ...

2868.1940740741 Days(s)

But now the cace is need to disply only 3 digits after point like 2868.194, pls help me to get that result...

Re: hi need urgent reply

n1ef5ng1 — Tue, 07 May 2013 07:08:48 GMT

Properties -> Number -> Select field -> decimal -> set it as 3

Re: hi need urgent reply

Tue, 07 May 2013 08:53:03 GMT

Yeah thanks for that rply ...now i am getting result like this ...

2868.1940740741 Days(s)

But now the cace is need to disply only 3 digits after point like 2868.194, pls help me to get that result...

Re: hi need urgent reply

Tue, 07 May 2013 08:53:15 GMT

Yeah thanks for that rply ...now i am getting result like this ...

2868.1940740741 Days(s)

But now the cace is need to disply only 3 digits after point like 2868.194, pls help me to get that result...

Re: hi need urgent reply

Gysbert_Wassenaar — Tue, 07 May 2013 09:00:10 GMT

Try num( sum(AHOT_MINUTES)/1440, '#.000')