topic Re: Floor Function in QlikView

Floor Function

Anonymous — Wed, 02 Sep 2015 10:26:34 GMT

How do I use floor function for date?

Thanks

Re: Floor Function

sunny_talwar — Wed, 02 Sep 2015 10:29:20 GMT

You can use to get just the date (excluding the time). For example try this:

Date(Floor(Now())) -> will give you just the date

Time(Frac(Now())) -> will give you just the time

Re: Floor Function

qlikmsg4u — Wed, 02 Sep 2015 10:29:22 GMT

Clearly it removes time part from the date

first try this in text object

=Now()

then try this

=Date(Floor(now()))

you will find the difference

Re: Floor Function

sunny_talwar — Wed, 02 Sep 2015 10:37:35 GMT

See if the attached helps:

Re: Floor Function

bharani8 — Tue, 25 Jul 2017 08:10:44 GMT

What is the diff btw =Date(Floor(now())) & =Date(now())... I see both returning same value

Re: Floor Function

Anil_Babu_Samineni — Tue, 25 Jul 2017 08:20:05 GMT

This is old thread, Some how look Floor() in help - Floor ‒ QlikView

Re: Floor Function

bharani8 — Tue, 25 Jul 2017 08:23:31 GMT

Saw that.. But not able to understand clearly.. On what circumstances floor func will be useful in Biz cases? any simple example / illustration ?

Re: Floor Function

Anil_Babu_Samineni — Tue, 25 Jul 2017 08:26:43 GMT

Example is there where we use floor() and ceil() in qlikview?

Re: Floor Function

bharani8 — Tue, 25 Jul 2017 08:32:23 GMT

TY!

Re: Floor Function

Siva_Sankar — Tue, 25 Jul 2017 08:32:51 GMT

Ceil function will round up a number. Ex: ceil(3.4) will return 4.

Floor will round down a number. Ex: floor(3.4) will return 3.

I use this when working with timestamps with hour and minutes values. Behind each date there's a number associated. Those dates with time, will have a decimal value (56321,23) where 23 represents the time and minutes (this is a random example!).

When in your model you don't need to use the hour, you can use ceil(Date) so your dates will always be DD/MM/YYYY 00:00:00 instead of DD/MM/YYYY 10:36:00.

This can also be used to format values. If you are working with big amounts, it might not tell you much to show the decimal. Instead of showing $26.354.201,31, you can use the ceil or floor function and round up/down the number, or using the format in the Number tab for the charts.

Advantage: It will helps to save lot of memory since it trims of timestamp.

For More: Get the Dates Right

-Siva

Re: Floor Function

Nagaraju_KCS — Tue, 25 Jul 2017 08:36:49 GMT

See this link..

https://www.qlikcommunity.org/message/335324

Re: Floor Function

bharani8 — Tue, 25 Jul 2017 08:42:18 GMT

This really cleared some doubt in my mind!!.. Thanks Raju &

topic Re: Floor Function in QlikView

Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Re: Floor Function

Nagaian Krishnamoorthy for explaining this!