topic Cross tab report-with each 30 mins interval in QlikView

Cross tab report-with each 30 mins interval

Tue, 11 Oct 2011 02:45:56 GMT

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.

Cross tab report-with each 30 mins interval

perumal_41 — Tue, 11 Oct 2011 04:06:58 GMT

Hi,

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

Cross tab report-with each 30 mins interval

Tue, 11 Oct 2011 09:56:57 GMT

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.

Cross tab report-with each 30 mins interval

Tue, 11 Oct 2011 20:41:14 GMT

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

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