topic Re: Hi in QlikView https://community.qlik.com/t5/QlikView/Hi/m-p/1265914#M872012 <HTML><HEAD></HEAD><BODY><P>Hello Soujanya, </P><P></P><P>For future posts please be sure to put the question or main issue in the subject line instead of 'Hi' for additional tips see&nbsp; <A href="https://community.qlik.com/message/846551">Getting Started: Questions and Discussion Threads</A></P><P></P><P>Best Regards, Sara </P></BODY></HTML> Fri, 18 Nov 2016 17:52:21 GMT Anonymous 2016-11-18T17:52:21Z Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1265911#M872009 <HTML><HEAD></HEAD><BODY><P>I have the following data with 3 fields, i want to find number of opened tickets which are not closed.</P><P>.And also i need to provide filters for year,quarter,month,week.<SPAN style="font-size: 13.3333px;">could any one guide me how can i do this.</SPAN></P><P></P><P></P><P></P><P></P><P>thanks</P><P>soujanya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1265911#M872009 2020-11-25T16:16:04Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1265912#M872010 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try something like this.</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14793808563358068" jivemacro_uid="_14793808563358068" modifiedtitle="true"> <P>=count(TicketId)-count({$&lt;closeddate ={'*'}&gt;} TicketId)</P> </PRE><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 17 Nov 2016 11:08:04 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1265912#M872010 ashfaq_haseeb 2016-11-17T11:08:04Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1265913#M872011 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq,</P><P>Thanks for your quick reply. Its working.</P></BODY></HTML> Fri, 18 Nov 2016 04:11:58 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1265913#M872011 2016-11-18T04:11:58Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1265914#M872012 <HTML><HEAD></HEAD><BODY><P>Hello Soujanya, </P><P></P><P>For future posts please be sure to put the question or main issue in the subject line instead of 'Hi' for additional tips see&nbsp; <A href="https://community.qlik.com/message/846551">Getting Started: Questions and Discussion Threads</A></P><P></P><P>Best Regards, Sara </P></BODY></HTML> Fri, 18 Nov 2016 17:52:21 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1265914#M872012 Anonymous 2016-11-18T17:52:21Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1265915#M872013 <HTML><HEAD></HEAD><BODY><P>Thank you Sara for correcting me.Sure from next time i will follow this.</P></BODY></HTML> Fri, 18 Nov 2016 18:08:33 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1265915#M872013 2016-11-18T18:08:33Z