Select previous month

[Anonymous]

Hello everyone,

I am trying to select the previous month to the one currently selected through a filter and I am not having much luck.

My dates are currently fed to qlik sense through a crosstable in the following format

Summary:

CrossTable(Date, [Bid Data], 6)

LOAD

     [41579],

     [41609],

     [41640],

     [41671],

     [41699],

     [41730],

     [41760],

     [41791],

     [41821],

     [41852],

     [41883],

     [41913],

     [41944],

     [41974],

     [42005],

     [42036],

     [42064],

     [42095],

     [42125],

     [42156],

     [42186],

     [42217],

     [42248],

     [42278],

     [42309],

     [42339],

     [42370],

     [42401],

     [42430]

I have coded the following formula to transform the numbers into dates :Date(Num#(Date),'YYYYMM') as Date

This is then turned into YearMonth in my master calendar.

Since the numbers jumps irregularly (normally in steps of 28-31) I am not sure how to code the variable to always give me the previous month.

Thank you very much in advance.