Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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