Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
5abi0001
Creator
Creator

max month where i have a value

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 😞

2 Replies
Michiel_QV_Fan
Specialist
Specialist

please do not create duplicate post.

Usage Guidelines for Qlik Community

5abi0001
Creator
Creator
Author

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. 🙂