https://community.qlik.com/t5/QlikView/Data-join-and-filter-by-Status/m-p/2038030#M1222603 <P>Hi Team,</P> <P>I receive daily files 1st Jan,2nd Jan,.......31 Dec 2022. And also when the new starts again i start getting the daily files for 2023 - 1st Jan......etc</P> <P>Got variety of fields - Process name, Status - Y/N, etc</P> <P>Requirement is that using the yearend file how do I lock 2022 data based on Status = 'Y' and show only 2023 by default in the dashboard.&nbsp;</P> <P>Requestor should see 2022 when they select the 2022 as the filter.</P> <P>Any thoughts/suggestions are much appreciated.</P> <P>Regards,</P> <P>Richard</P> Wed, 15 Feb 2023 05:33:54 GMT richard24best 2023-02-15T05:33:54Z https://community.qlik.com/t5/QlikView/Data-join-and-filter-by-Status/m-p/2038030#M1222603 <P>Hi Team,</P> <P>I receive daily files 1st Jan,2nd Jan,.......31 Dec 2022. And also when the new starts again i start getting the daily files for 2023 - 1st Jan......etc</P> <P>Got variety of fields - Process name, Status - Y/N, etc</P> <P>Requirement is that using the yearend file how do I lock 2022 data based on Status = 'Y' and show only 2023 by default in the dashboard.&nbsp;</P> <P>Requestor should see 2022 when they select the 2022 as the filter.</P> <P>Any thoughts/suggestions are much appreciated.</P> <P>Regards,</P> <P>Richard</P> Wed, 15 Feb 2023 05:33:54 GMT https://community.qlik.com/t5/QlikView/Data-join-and-filter-by-Status/m-p/2038030#M1222603 richard24best 2023-02-15T05:33:54Z https://community.qlik.com/t5/QlikView/Data-join-and-filter-by-Status/m-p/2038041#M1222604 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/68579">@richard24best</a>&nbsp;Could you please elaborate on your requirement? Also, please post some sample data along with expected output.</P> Wed, 15 Feb 2023 05:51:41 GMT https://community.qlik.com/t5/QlikView/Data-join-and-filter-by-Status/m-p/2038041#M1222604 sidhiq91 2023-02-15T05:51:41Z