Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is It Possible In QlikView Or Not
PLEASE HELP ME FIND OUT 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.
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
So No body know how to make hour interval
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];
You can try with Class / Interval function to create the buckets for the hours.
Dear Anand
I done It.