topic Re: How to Find Hourly Sale in QlikView

How to Find Hourly Sale

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

Dear Team,

i stuck a requiremnet.I want to Caluclate.Hourly Sales.

In Morning 8 AM TO 9 AM.....

9 AM TO 10 AM

1 PM TO 2 PM..

How is it Possible in qlikview..Please help me For Solving This.

Regards

Gourav

Re: How to Find Hourly Sale

panipat1990 — Wed, 06 Dec 2017 10:33:41 GMT

Is It Possible In QlikView Or Not

Re: How to Find Hourly Sale

panipat1990 — Wed, 06 Dec 2017 11:13:45 GMT

PLEASE HELP ME FIND OUT HOURLY SALE

Re: How to Find Hourly Sale

jonathandienst — Wed, 06 Dec 2017 11:18:32 GMT

Its certainly possible.

Cant really help you more than that without knowing what sort of data you and what sort of reporting you need to do.

If you don't know where to start, work through the on-line training material or attend paid training to understand how to work in QV, or get one of the good Qlikview books. Search here for more information.

Re: How to Find Hourly Sale

panipat1990 — Wed, 06 Dec 2017 11:22:52 GMT

Kindly Tell me how is it possible.

i want to create column based on Hour

First Column 8 AM TO 9 AM

9 AM TO 10 AM

11 AM TO 12 PM

01 PM TO 2 PM

How is it

Re: How to Find Hourly Sale

panipat1990 — Wed, 06 Dec 2017 13:14:40 GMT

So No body know how to make hour interval

Re: How to Find Hourly Sale

Anonymous — Wed, 06 Dec 2017 14:38:41 GMT

Hi Sikka,

could you give more information about the table, field and field type? Try something like this:

[TABLENAME]:

LOAD

[COLUMNNAME],

PICK(HOUR(COLUMNNAME),

DUAL ('8:00 / 9:00', 1),

DUAL ('9:00 / 10:00', 2) )

as [NameAsYouPlease];

Re: How to Find Hourly Sale

its_anandrjs — Wed, 06 Dec 2017 14:40:45 GMT

You can try with Class / Interval function to create the buckets for the hours.

Re: How to Find Hourly Sale

panipat1990 — Thu, 07 Dec 2017 05:51:30 GMT

Dear Anand

I done It.