https://community.qlik.com/t5/QlikView/Query-with-Date-and-Straight-Table/m-p/1730370#M722025 <P>Hi</P><P>I have a straight table like below . There is also a filter in the page for F-Date.<BR />The expression I am using is below. Just a dummy one to show all the fields as dimensions only.<BR />But for Status=OSC,I don't want to apply the date filter (the two last rows) as some of the values of F_Date will be null for OSC however for the other two status(TRC &amp; ACT) I still need to apply the date filter.</P><P>Is it possible to achieve such a condition? Can you please help?</P><P>Expression:</P><P>=Sum({&lt;[Category]-={'Labour'}<BR />[F_DATE] = {"&lt;=$(=max(FISCAL_DATE))"}<BR />&gt;}1)</P><P>Project_id&nbsp; &nbsp;Status&nbsp; &nbsp;Amount&nbsp; &nbsp;Category&nbsp; &nbsp; &nbsp; F_Date<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRC&nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02-Mar-20<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRC&nbsp; &nbsp; &nbsp; &nbsp;300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02-Mar-20<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ACT&nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Non Labour 01-Apr-20<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OSC&nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23-Feb-19<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OSC&nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Non Labour</P><P><BR />Many Thanks in advance</P><P>Regards</P><P>Ankhi</P> Sat, 16 Nov 2024 00:16:06 GMT Ankhi 2024-11-16T00:16:06Z https://community.qlik.com/t5/QlikView/Query-with-Date-and-Straight-Table/m-p/1730370#M722025 <P>Hi</P><P>I have a straight table like below . There is also a filter in the page for F-Date.<BR />The expression I am using is below. Just a dummy one to show all the fields as dimensions only.<BR />But for Status=OSC,I don't want to apply the date filter (the two last rows) as some of the values of F_Date will be null for OSC however for the other two status(TRC &amp; ACT) I still need to apply the date filter.</P><P>Is it possible to achieve such a condition? Can you please help?</P><P>Expression:</P><P>=Sum({&lt;[Category]-={'Labour'}<BR />[F_DATE] = {"&lt;=$(=max(FISCAL_DATE))"}<BR />&gt;}1)</P><P>Project_id&nbsp; &nbsp;Status&nbsp; &nbsp;Amount&nbsp; &nbsp;Category&nbsp; &nbsp; &nbsp; F_Date<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRC&nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02-Mar-20<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRC&nbsp; &nbsp; &nbsp; &nbsp;300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02-Mar-20<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ACT&nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Non Labour 01-Apr-20<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OSC&nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23-Feb-19<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OSC&nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Non Labour</P><P><BR />Many Thanks in advance</P><P>Regards</P><P>Ankhi</P> Sat, 16 Nov 2024 00:16:06 GMT https://community.qlik.com/t5/QlikView/Query-with-Date-and-Straight-Table/m-p/1730370#M722025 Ankhi 2024-11-16T00:16:06Z https://community.qlik.com/t5/QlikView/Query-with-Date-and-Straight-Table/m-p/1734976#M722026 <P>Best I have is the following:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822</A></P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm</A></P><P>That should allow you to check things to be sure you have the correct syntax on things etc.&nbsp; &nbsp;The first design blog post has some other related posts linked at the bottom just FYI.</P><P>Regards,<BR />Brett</P> Tue, 11 Aug 2020 19:20:37 GMT https://community.qlik.com/t5/QlikView/Query-with-Date-and-Straight-Table/m-p/1734976#M722026 Brett_Bleess 2020-08-11T19:20:37Z