https://community.qlik.com/t5/QlikView/rows-with-same-product-status-in-differrnt-hour-and-month/m-p/2005328#M1289464 <DIV id="D03RKFHV2ES-1668605777.511429-thread-list-threads-flexpane_1668606026.894649" class="c-virtual_list__item c-virtual_list__item--initial-activeitem" tabindex="0" role="listitem" aria-setsize="-1" data-qa="virtual-list-item" data-item-key="1668606026.894649"> <DIV class="c-message_kit__background c-message_kit__message c-message_kit__thread_message" role="presentation" data-qa="message_container" data-qa-unprocessed="false" data-qa-placeholder="false"> <DIV class="c-message_kit__hover" role="document" aria-roledescription="message" data-qa-hover="true"> <DIV class="c-message_kit__actions c-message_kit__actions--default"> <DIV class="c-message_kit__gutter"> <DIV class="c-message_kit__gutter__right" role="presentation" data-qa="message_content"> <DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text"> <DIV class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text"> <DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"> <DIV class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first"> <DIV class="p-rich_text_block" dir="auto"> <DIV class="p-rich_text_section">Hi everyone,</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> <DIV class="p-rich_text_section">I have a table where each row is a product and its status at that time.</DIV> <DIV class="p-rich_text_section"><BR />im trying to take all the rows that exists on the first day of the&nbsp; month (current month filter)&nbsp;&nbsp;with status (active) at 00:00 and were also exist at the end of the last month with the same status at 23:55 (on the last day of the month)</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV id="D03RKFHV2ES-1668605777.511429-thread-list-threads-flexpane_input" class="c-virtual_list__item" tabindex="-1" role="listitem" aria-setsize="-1" data-qa="virtual-list-item" data-item-key="input"> <DIV class="p-threads_footer__input_container p-threads_footer__input_container--sticky_composer p-threads_footer__input_container--thread_typing_indicators" data-qa="reply_container"> <DIV>&nbsp;</DIV> <DIV class="p-threads_footer__input p-message_input_unstyled" role="group" aria-label="composer"> <DIV class="p-message_input__input_container_unstyled c-wysiwyg_container c-wysiwyg_container--theme_light c-wysiwyg_container--with_footer c-wysiwyg_container--theme_light_bordered c-wysiwyg_container--double_decker c-basic_container c-basic_container--size_medium" data-max-lines="16"> <DIV class="c-basic_container__body"> <DIV class="c-wysiwyg_container__formatting" role="toolbar" aria-orientation="horizontal" aria-label="Formatting" data-qa="wysiwyg-container_formatting-enabled"> <DIV class="p-texty_sticky_formatting_bar"> <DIV> <DIV class="p-composer__body p-composer__body--visible p-composer__body--unstyled">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Mon, 26 Jan 2026 18:19:17 GMT SharonBlank 2026-01-26T18:19:17Z https://community.qlik.com/t5/QlikView/rows-with-same-product-status-in-differrnt-hour-and-month/m-p/2005328#M1289464 <DIV id="D03RKFHV2ES-1668605777.511429-thread-list-threads-flexpane_1668606026.894649" class="c-virtual_list__item c-virtual_list__item--initial-activeitem" tabindex="0" role="listitem" aria-setsize="-1" data-qa="virtual-list-item" data-item-key="1668606026.894649"> <DIV class="c-message_kit__background c-message_kit__message c-message_kit__thread_message" role="presentation" data-qa="message_container" data-qa-unprocessed="false" data-qa-placeholder="false"> <DIV class="c-message_kit__hover" role="document" aria-roledescription="message" data-qa-hover="true"> <DIV class="c-message_kit__actions c-message_kit__actions--default"> <DIV class="c-message_kit__gutter"> <DIV class="c-message_kit__gutter__right" role="presentation" data-qa="message_content"> <DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text"> <DIV class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text"> <DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"> <DIV class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first"> <DIV class="p-rich_text_block" dir="auto"> <DIV class="p-rich_text_section">Hi everyone,</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> <DIV class="p-rich_text_section">I have a table where each row is a product and its status at that time.</DIV> <DIV class="p-rich_text_section"><BR />im trying to take all the rows that exists on the first day of the&nbsp; month (current month filter)&nbsp;&nbsp;with status (active) at 00:00 and were also exist at the end of the last month with the same status at 23:55 (on the last day of the month)</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV id="D03RKFHV2ES-1668605777.511429-thread-list-threads-flexpane_input" class="c-virtual_list__item" tabindex="-1" role="listitem" aria-setsize="-1" data-qa="virtual-list-item" data-item-key="input"> <DIV class="p-threads_footer__input_container p-threads_footer__input_container--sticky_composer p-threads_footer__input_container--thread_typing_indicators" data-qa="reply_container"> <DIV>&nbsp;</DIV> <DIV class="p-threads_footer__input p-message_input_unstyled" role="group" aria-label="composer"> <DIV class="p-message_input__input_container_unstyled c-wysiwyg_container c-wysiwyg_container--theme_light c-wysiwyg_container--with_footer c-wysiwyg_container--theme_light_bordered c-wysiwyg_container--double_decker c-basic_container c-basic_container--size_medium" data-max-lines="16"> <DIV class="c-basic_container__body"> <DIV class="c-wysiwyg_container__formatting" role="toolbar" aria-orientation="horizontal" aria-label="Formatting" data-qa="wysiwyg-container_formatting-enabled"> <DIV class="p-texty_sticky_formatting_bar"> <DIV> <DIV class="p-composer__body p-composer__body--visible p-composer__body--unstyled">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/rows-with-same-product-status-in-differrnt-hour-and-month/m-p/2005328#M1289464 SharonBlank 2026-01-26T18:19:17Z