https://community.qlik.com/t5/App-Development/Filter-with-an-if-statement-embedded-causing-performance-issue/m-p/2478276#M100456 <P>So if I have more than 1 filter then I have to include them all in the distinct,&nbsp; also have to join the filters to the existing data model so I will have to create an alias ..might work..thanks</P> Tue, 27 Aug 2024 19:10:59 GMT rickarora 2024-08-27T19:10:59Z https://community.qlik.com/t5/App-Development/Filter-with-an-if-statement-embedded-causing-performance-issue/m-p/2477799#M100405 <P>I have a status in the table and I want to show fiscal years only associated with that status in the filters.</P> <P>So filter is..If(status =sold, fiscal year)</P> <P>The filter take a few minutes to render..</P> <P>I have tried to create a concatenated table in the load script that has a list of filters but that doesn't seem practical as I have to list each filter..</P> <P>Any ideas all?</P> <P>Thanks in advance!</P> <P>&nbsp;</P> Fri, 23 Aug 2024 17:31:20 GMT https://community.qlik.com/t5/App-Development/Filter-with-an-if-statement-embedded-causing-performance-issue/m-p/2477799#M100405 rickarora 2024-08-23T17:31:20Z https://community.qlik.com/t5/App-Development/Filter-with-an-if-statement-embedded-causing-performance-issue/m-p/2478276#M100456 <P>So if I have more than 1 filter then I have to include them all in the distinct,&nbsp; also have to join the filters to the existing data model so I will have to create an alias ..might work..thanks</P> Tue, 27 Aug 2024 19:10:59 GMT https://community.qlik.com/t5/App-Development/Filter-with-an-if-statement-embedded-causing-performance-issue/m-p/2478276#M100456 rickarora 2024-08-27T19:10:59Z