topic max month where i have a value in QlikView https://community.qlik.com/t5/QlikView/max-month-where-i-have-a-value/m-p/116019#M509500 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hey people! </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i have the following problem -&gt; i have a table which has the following construction:</P><P style="font-size: 13.3333px;">TicketTable:</P><P style="font-size: 13.3333px;">Date, SumTickets</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">and i have a filter where i can filter the date .. i have the following issue ..</P><P style="font-size: 13.3333px;">in the ticketTable: </P><P style="font-size: 13.3333px;">i have till oktober values for sumtickets</P><P style="font-size: 13.3333px;">when the current month (november) is over, i will get a value for oktober </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">now i want that if i filter till novemeber, i want to have the max month where i have a value -&gt; so in this case i want setember!</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">how i can do it? i have no clue <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Wed, 07 Nov 2018 14:02:47 GMT 5abi0001 2018-11-07T14:02:47Z max month where i have a value https://community.qlik.com/t5/QlikView/max-month-where-i-have-a-value/m-p/116019#M509500 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hey people! </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i have the following problem -&gt; i have a table which has the following construction:</P><P style="font-size: 13.3333px;">TicketTable:</P><P style="font-size: 13.3333px;">Date, SumTickets</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">and i have a filter where i can filter the date .. i have the following issue ..</P><P style="font-size: 13.3333px;">in the ticketTable: </P><P style="font-size: 13.3333px;">i have till oktober values for sumtickets</P><P style="font-size: 13.3333px;">when the current month (november) is over, i will get a value for oktober </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">now i want that if i filter till novemeber, i want to have the max month where i have a value -&gt; so in this case i want setember!</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">how i can do it? i have no clue <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Wed, 07 Nov 2018 14:02:47 GMT https://community.qlik.com/t5/QlikView/max-month-where-i-have-a-value/m-p/116019#M509500 5abi0001 2018-11-07T14:02:47Z Re: max month where i have a value https://community.qlik.com/t5/QlikView/max-month-where-i-have-a-value/m-p/116020#M509501 <HTML><HEAD></HEAD><BODY><P>please do not create duplicate post.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-5980">Usage Guidelines for Qlik Community</A></P></BODY></HTML> Wed, 07 Nov 2018 15:07:21 GMT https://community.qlik.com/t5/QlikView/max-month-where-i-have-a-value/m-p/116020#M509501 Michiel_QV_Fan 2018-11-07T15:07:21Z Re: max month where i have a value https://community.qlik.com/t5/QlikView/max-month-where-i-have-a-value/m-p/116021#M509502 <HTML><HEAD></HEAD><BODY><P>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. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 08 Nov 2018 11:54:51 GMT https://community.qlik.com/t5/QlikView/max-month-where-i-have-a-value/m-p/116021#M509502 5abi0001 2018-11-08T11:54:51Z