topic Re: Help for expression date-2 in QlikView https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166257#M897300 <HTML><HEAD></HEAD><BODY><P>Please share sample application</P></BODY></HTML> Thu, 28 Jul 2016 12:03:07 GMT saimahasan 2016-07-28T12:03:07Z Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166253#M897296 <HTML><HEAD></HEAD><BODY><P>Hello, I have another problem when I write</P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">({&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: maroon;">AnnéeMois</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"> = {'$(=monthname(AddMonths([Date Calendrier],-2)))'}&gt;} </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: maroon;">Vol_Appels</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">) </SPAN>&nbsp; in expression, <SPAN lang="en">it shows me 0 in result.</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN lang="en">Can you help me please? thx</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166253#M897296 2020-11-25T16:16:04Z Re: Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166254#M897297 <HTML><HEAD></HEAD><BODY><P>to know what is issue, you have to share Sample data.</P><P></P><P>Because Output is not null '-' , it is '0', it means expression is correct,.</P></BODY></HTML> Thu, 28 Jul 2016 10:17:44 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166254#M897297 tyagishaila 2016-07-28T10:17:44Z Re: Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166255#M897298 <HTML><HEAD></HEAD><BODY><P>How does your Date field look like?</P></BODY></HTML> Thu, 28 Jul 2016 10:20:11 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166255#M897298 MindaugasBacius 2016-07-28T10:20:11Z Re: Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166256#M897299 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="80"></TD><TD width="80">volcall</TD><TD width="80">Mois</TD><TD width="80">année</TD></TR><TR><TD height="20">A</TD><TD align="right">50</TD><TD align="right">1</TD><TD align="right">2001</TD></TR><TR><TD height="20">b</TD><TD align="right">30</TD><TD align="right">2</TD><TD align="right">2001</TD></TR><TR><TD height="20">c</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">2001</TD></TR><TR><TD height="20">d</TD><TD align="right">25</TD><TD align="right">4</TD><TD align="right">2001</TD></TR><TR><TD height="20">e</TD><TD align="right">5</TD><TD align="right">5</TD><TD align="right">2001</TD></TR><TR><TD height="20">f</TD><TD align="right">5</TD><TD align="right">6</TD><TD align="right">2001</TD></TR><TR><TD height="20">i</TD><TD align="right">6</TD><TD align="right">7</TD><TD align="right">2001</TD></TR><TR><TD height="20">g</TD><TD align="right">8</TD><TD align="right">8</TD><TD align="right">2001</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 28 Jul 2016 11:52:45 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166256#M897299 2016-07-28T11:52:45Z Re: Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166257#M897300 <HTML><HEAD></HEAD><BODY><P>Please share sample application</P></BODY></HTML> Thu, 28 Jul 2016 12:03:07 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166257#M897300 saimahasan 2016-07-28T12:03:07Z Re: Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166258#M897301 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: blue;">sum</SPAN><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: black;">({&lt;</SPAN><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: maroon;">AnnéeMois</SPAN><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: black;"> = {<STRONG>"</STRONG>$(=monthname(AddMonths([Date Calendrier],-2)))<STRONG>"</STRONG>}&gt;} </SPAN><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: maroon;">Vol_Appels</SPAN><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: black;">)</SPAN></P><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: black;">Use Double Quotes<BR /></SPAN></P></BODY></HTML> Thu, 28 Jul 2016 12:05:50 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166258#M897301 Anil_Babu_Samineni 2016-07-28T12:05:50Z Re: Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166259#M897302 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 320px;"><TBODY><TR><TD height="20" style="border: 0px solid black;" width="80"></TD><TD style="border: 0px solid black;" width="80">volapp</TD><TD style="border: 0px solid black;" width="80">Mois</TD><TD style="border: 0px solid black;" width="80">année</TD></TR><TR><TD height="20" style="border: 0px solid black;">A</TD><TD align="right" style="border: 0px solid black;">50</TD><TD align="right" style="border: 0px solid black;">1</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR><TR><TD height="20" style="border: 0px solid black;">b</TD><TD align="right" style="border: 0px solid black;">30</TD><TD align="right" style="border: 0px solid black;">2</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR><TR><TD height="20" style="border: 0px solid black;">c</TD><TD align="right" style="border: 0px solid black;">1</TD><TD align="right" style="border: 0px solid black;">3</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR><TR><TD height="20" style="border: 0px solid black;">d</TD><TD align="right" style="border: 0px solid black;">25</TD><TD align="right" style="border: 0px solid black;">4</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR><TR><TD height="20" style="border: 0px solid black;">e</TD><TD align="right" style="border: 0px solid black;">5</TD><TD align="right" style="border: 0px solid black;">5</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR><TR><TD height="20" style="border: 0px solid black;">f</TD><TD align="right" style="border: 0px solid black;">5</TD><TD align="right" style="border: 0px solid black;">6</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR><TR><TD height="20" style="border: 0px solid black;">i</TD><TD align="right" style="border: 0px solid black;">6</TD><TD align="right" style="border: 0px solid black;">7</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR><TR><TD height="20" style="border: 0px solid black;">g</TD><TD align="right" style="border: 0px solid black;">8</TD><TD align="right" style="border: 0px solid black;">8</TD><TD align="right" style="border: 0px solid black;">2001</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 28 Jul 2016 12:08:00 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166259#M897302 2016-07-28T12:08:00Z Re: Help for expression date-2 https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166260#M897303 <HTML><HEAD></HEAD><BODY><P>it's not working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P>it's ok for the present month and month-1 but not for month -2 i don't know why </P></BODY></HTML> Thu, 28 Jul 2016 12:50:01 GMT https://community.qlik.com/t5/QlikView/Help-for-expression-date-2/m-p/1166260#M897303 2016-07-28T12:50:01Z