Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

5abi0001
Contributor

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
michielvandegoo
Valued Contributor

Re: max month where i have a value

please do not create duplicate post.

Usage Guidelines for Qlik Community

Highlighted
5abi0001
Contributor

Re: max month where i have a value

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