show me the last month from today (retrospective)

[beck_bakytbek]

Hi Folks,

i got a Question, i have the following data:

Date, Month, Sales

02.01.2019 , Jan, 2

02.02.2019,  Feb, 3

03.03.2019, Mrz, 4

05.04.2019, Apr, 5

06.05.2019, Mai, 6

06.06.2019, Jun, 7

my issu is, when i select the month mai, so i want to see all value from jan until mai, i tried to solve it by set Expression, but it does not work.

Does andybody have any idea?

thanks a lot

Beck

[SumitaKumari]

we can create new field "month_in_number "  from date and use same field for selection

[dplr-rn]

check AsOfDate concept
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

[beck_bakytbek]

Hi SumitaKumari,

thanks a lot for your responce, do you have an example?

[beck_bakytbek]

Hi Dilipranjith,

thanks a lot for your reponse