Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot Table With Dates As The Fields?

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/121/3/121/4/121/5/121/6/121/7/12
Expired10251521523240
Not Yet Expired1275897100199188
Total321001049115222437

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?

Tags (1)
1 Reply
deepakk
Valued Contributor III

Re: Pivot Table With Dates As The Fields?

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

Community Browser