Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

How to Find Hourly Sale

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     

8 Replies
panipat1990
Contributor II

Re: How to Find Hourly Sale

Is It Possible In QlikView Or Not

panipat1990
Contributor II

Re: How to Find Hourly Sale

PLEASE HELP ME FIND OUT HOURLY SALE

MVP
MVP

Re: How to Find Hourly Sale

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.

panipat1990
Contributor II

Re: How to Find Hourly Sale

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

panipat1990
Contributor II

Re: How to Find Hourly Sale

So No body know how to make hour interval

jonnieyacoub
Contributor

Re: How to Find Hourly Sale

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

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

panipat1990
Contributor II

Re: How to Find Hourly Sale

Dear Anand

I done It.