Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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!!

0 Replies