Cross tab report-with each 30 mins interval

[#1]

Hi,

I need to create a cross tab report in qlikview.I guess for this I can use a Pivot table.Reporting time period is 12 AM to 12 PM.This report should provide data for each 30 minutes interval.User can select the date from the parameter.

TimePeriod	luggage bags	wallet	purses	Bag packs	Tote	hand Bag	laptop bags
12.00-12.30 AM	2	0	0	0	0	1	0
12.30-1.00 AM	0	1	1
1.00 AM-1.30 AM
---------------------
--------------------
------------------------
-----------------------
10.30PM-11.00 PM
11.00 PM -11.30 PM
11.30 Pm-12.00 PM

In the database there are purchase time for each item.For example:

09/26/2011 12.10 AM Luggage bags

09/26/2011  12.08 AM Luggage bags

09/26/2011  12.15 AM Hand bags

09/26/2011 12.35 AM Wallet

09/26/2011  12.40 AM Purses

can any one tell how can I create these 30 minutes interval dimensions in qlikview?Please also let me know whether item names also would be in the dimension ?

Thanks.

[perumal_41]

Hi,

You try  class( ) function.this function useful for your problem.

[#3]

hi,

you can use crosstable for this.

when you load your excel sheet then click on next , there you get a crosstable option under prefixes.

then give your parameters,

qualifier field- 1

attribute field- product name

data field- no of product sold in that interval.

for the 30 minutes interval, you can use buckets or interval match.

[#4]

Thanks for all the replies.I got the solution from below link

http://community.qlik.com/message/30241#30241