How do I show different time periods for same invoice date??

Fri, 28 Feb 2014 15:16:54 GMT

To really help me with this I need to give you background on how this works.....

We invoice a customer for a 7 day period of "usage" - that invoice is called an S7 ; they then receive a new S7 , 7 days later, but there may be adjustments to the prior period S7, which now shows up on current invoice under category : S14.

For example:

S7 - Invoiced on 1/21/2014

activity of 1/4 - 1/10/2014

on that same invoice is prior period S7 - now referred to as S14.

S14 activity period : 12/28 - 1/3/2014

SEE ATTACHED EXAMPLE to explain the above -

The only way I can identify the charges for the "S14 Prior Period" is via the Category / SubCategory Fields (see attached pic)

I am up for any suggestions on how to do this!

Thanks so much!!

topic How do I show different time periods for same invoice date?? in QlikView

How do I show different time periods for same invoice date??