https://community.qlik.com/t5/Reporting-Service-Alerting/Limit-column/m-p/2134402#M648 <P>Hello! <BR />I have the following question: <BR />How can I restrict data in a column in a table? For example, we have all statuses and only need certain ones that are not closed. I have already tried with if command to exclude the certain statuses, and set close date to 0, but nothing works. Perhaps someone has a tip for me? <BR />I tried this: in the state column, and then show column if:<BR />If([State]= "certain states", [State]) <BR />[Completion date]= zero(), <BR />If(([Closing Date]=Null()), [State])</P> <P>Thanks in advance!</P> Fri, 15 Nov 2024 21:17:36 GMT Nika3 2024-11-15T21:17:36Z https://community.qlik.com/t5/Reporting-Service-Alerting/Limit-column/m-p/2134402#M648 <P>Hello! <BR />I have the following question: <BR />How can I restrict data in a column in a table? For example, we have all statuses and only need certain ones that are not closed. I have already tried with if command to exclude the certain statuses, and set close date to 0, but nothing works. Perhaps someone has a tip for me? <BR />I tried this: in the state column, and then show column if:<BR />If([State]= "certain states", [State]) <BR />[Completion date]= zero(), <BR />If(([Closing Date]=Null()), [State])</P> <P>Thanks in advance!</P> Fri, 15 Nov 2024 21:17:36 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Limit-column/m-p/2134402#M648 Nika3 2024-11-15T21:17:36Z https://community.qlik.com/t5/Reporting-Service-Alerting/Limit-column/m-p/2134413#M649 <P>write set analysis for it</P> <P>try like</P> <P>Only({&lt;<SPAN>statuses={'Not Closed'}</SPAN>&gt;}States)</P> Fri, 03 Nov 2023 09:31:59 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Limit-column/m-p/2134413#M649 PrashantSangle 2023-11-03T09:31:59Z https://community.qlik.com/t5/Reporting-Service-Alerting/Limit-column/m-p/2134436#M650 <P>Unfortunately, that doesn't work either<span class="lia-unicode-emoji" title=":pensive_face:">😔</span></P> Fri, 03 Nov 2023 10:30:56 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Limit-column/m-p/2134436#M650 Nika3 2023-11-03T10:30:56Z