Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.