I don't have any values for period 10 through 12 as of yet in my raw data, so it can't show up. Also, I can't start typing up empty lines with strictly my missing periods in the raw data just to accomplish my goal...
You need to load a master calendar which covers those dates as well. Link the master calendar to your expenses via day or month (depending on the granularity of your data). You may want to drop the derived date fields (eg Period) from your expenses data and create the derived fields in the master calendar.
There are plenty of posts on this site, just serach for "master calendar".
Hope that helps
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I've tried addind a correspondance table for my months and period numbers. I thought that would resolve but it unfortunatly doesn't. As you've suggested , I searched master calendars, and from what I gather, the table with all months still exist, and I can bring it up with all 12 values, but when I use Month as a dimention in a pivot table, it will not bring back any values for Months that don't have a [Montant].
I'm not finding the Master calendar posts I found realy usefull for Pivot tables. And the first result Google brings back when I search for "Qlikview Master Calendar Pivot Table" is this thread