Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
panipat1990
Creator II
Creator 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
Creator II
Creator II
Author

Is It Possible In QlikView Or Not

panipat1990
Creator II
Creator II
Author

PLEASE HELP ME FIND OUT HOURLY SALE

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
panipat1990
Creator II
Creator II
Author

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
Creator II
Creator II
Author

So No body know how to make hour interval

Anonymous
Not applicable

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];

its_anandrjs

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

panipat1990
Creator II
Creator II
Author

Dear Anand

I done It.