max month where i have a value

[5abi0001]

Hey people!

i have the following problem -> i have a table which has the following construction:

TicketTable:

Date, SumTickets

and i have a filter where i can filter the date .. i have the following issue ..

in the ticketTable:

i have till oktober values for sumtickets

when the current month (november) is over, i will get a value for oktober

now i want that if i filter till novemeber, i want to have the max month where i have a value -> so in this case i want setember!

how i can do it? i have no clue 😞

[Michiel_QV_Fan]

please do not create duplicate post.

Usage Guidelines for Qlik Community

[5abi0001]

hey - sorry for this .. it created it automatically, because when i press post, it does not work and so i refreshed and it created it double. 🙂