Pivot Table With Dates As The Fields?

Thu, 19 Jul 2012 04:34:59 GMT

What is the best way to go about making a pivot table that will display dates across the top, and a count of the records below it? I have a set of data (that changes daily) that contains the UPC of an item, and it's expiration date. For each day, I need to show the count of items that are past/have met their expiration date, and the count of items that an expiration date in the future. It would look something like this:

	1/2/12	1/3/12	1/4/12	1/5/12	1/6/12	1/7/12
Expired	10	25	152	15	23	240
Not Yet Expired	12	75	897	100	199	188
Total	32	100	1049	115	222	437

In the raw data, it's just a UPC and an expiration date.

Or, am I going about this completely the wrong way? Could a straight table with expressions do this?

Re: Pivot Table With Dates As The Fields?

deepakk — Thu, 19 Jul 2012 06:05:58 GMT

hi,

You can use the pivot table. With expiry date as dimension and count of items as expression.

If you can have two expression for expired and Not yet expired. Or you have it as a field then you can add it as dimension.

You can drag the exipry date to get the result.

Deepak

topic Pivot Table With Dates As The Fields? in QlikView

Pivot Table With Dates As The Fields?

Re: Pivot Table With Dates As The Fields?