topic Re: Problem Number/Character? in QlikView https://community.qlik.com/t5/QlikView/Problem-Number-Character/m-p/768859#M1298464 <HTML><HEAD></HEAD><BODY><P>please provide sample app</P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 20 Dec 2014 00:30:29 GMT MarcoWedel 2014-12-20T00:30:29Z Problem Number/Character? https://community.qlik.com/t5/QlikView/Problem-Number-Character/m-p/768858#M1298460 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="color: #808080; font-size: 8pt;"><EM><STRONG>I Have defined</STRONG></EM></SPAN></P><P><SPAN style="color: #808080; font-size: 8pt;"><EM><STRONG>weekNrSysDate</STRONG></EM></SPAN><SPAN style="font-size: 8pt;">='02'; </SPAN></P><P><SPAN style="font-size: 8pt;">i have a query where column is:</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Courier;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">to_char(</SPAN><SPAN style="font-size: 10pt; font-family: Courier;">datecolumn</SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">,</SPAN><SPAN style="color: #ff0000; font-size: 10pt; font-family: Courier;">'iw'</SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">)</SPAN><SPAN style="font-size: 10pt; font-family: Courier;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">as</SPAN><SPAN style="font-size: 10pt; font-family: Courier;"> BWeeknr</SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: Courier;">THEN i have </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Courier;">Expression:</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">( {&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">BMIYEAR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(Yearcompare)"</SPAN><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">BMIWEEKNR</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(WeekNrSysDate)"</SPAN><SPAN style="font-size: 8pt;">}&gt;} SALES</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">yearcompare is character value</SPAN></P><P><SPAN style="font-size: 8pt;">but when i now define </SPAN></P><P></P><P><SPAN style="color: #808080; font-size: 8pt;"><EM><STRONG>WeekNrSysDate</STRONG></EM></SPAN><SPAN style="font-size: 8pt;">=0; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">and query:</SPAN></P><P></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">to_number(to_char(</SPAN><SPAN style="font-size: 10pt; font-family: Courier;">datecolumn</SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">,</SPAN><SPAN style="color: #ff0000; font-size: 10pt; font-family: Courier;">'iw'</SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">))</SPAN><SPAN style="font-size: 10pt; font-family: Courier;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier;">as</SPAN><SPAN style="font-size: 10pt; font-family: Courier;"> BWeeknr</SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 10pt; font-family: Courier;">my expression won't work?</SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 10pt; font-family: Courier;">i don't know why?</SPAN></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Problem-Number-Character/m-p/768858#M1298460 2026-01-26T18:19:17Z Re: Problem Number/Character? https://community.qlik.com/t5/QlikView/Problem-Number-Character/m-p/768859#M1298464 <HTML><HEAD></HEAD><BODY><P>please provide sample app</P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 20 Dec 2014 00:30:29 GMT https://community.qlik.com/t5/QlikView/Problem-Number-Character/m-p/768859#M1298464 MarcoWedel 2014-12-20T00:30:29Z