topic Re: Correct the expr in QlikView https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030990#M464700 <HTML><HEAD></HEAD><BODY><P>Hi Subba,</P><P></P><P>Try this:</P><P></P><P>=if=If(GetSelectedCount(Quarter)=0,$(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">varCurQtr</SPAN>),GetFieldSelections(Quarter))</P><P></P><P>Regards,</P><P>Carlos</P></BODY></HTML> Thu, 14 Apr 2016 03:13:36 GMT clondono 2016-04-14T03:13:36Z Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030981#M464691 <HTML><HEAD></HEAD><BODY><P>If(GetSelectedCount(Quarter)=0,'$(=varCurQtr)',GetFieldSelections(Quarter))</P><P></P><P>getting expected ')' error..</P></BODY></HTML> Thu, 14 Apr 2016 01:36:10 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030981#M464691 2016-04-14T01:36:10Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030982#M464692 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>Try,</EM><BR /></SPAN></P><P><EM style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></EM></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>If(GetSelectedCount(Quarter)=0,'$(varCurQtr)',GetFieldSelections(Quarter))</EM></SPAN></P></BODY></HTML> Thu, 14 Apr 2016 01:44:25 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030982#M464692 tamilarasu 2016-04-14T01:44:25Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030983#M464693 <HTML><HEAD></HEAD><BODY><P>Remove the&nbsp; "=' symbol&nbsp; before the variable and try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">If(GetSelectedCount(Quarter)=0<STRONG>,'$(varCurQtr)',</STRONG>GetFieldSelections(Quarter))</SPAN></P></BODY></HTML> Thu, 14 Apr 2016 01:51:36 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030983#M464693 Chanty4u 2016-04-14T01:51:36Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030984#M464694 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply, it was showing same error again. It was not resolved.</P></BODY></HTML> Thu, 14 Apr 2016 01:52:13 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030984#M464694 2016-04-14T01:52:13Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030985#M464695 <HTML><HEAD></HEAD><BODY><P>same error</P></BODY></HTML> Thu, 14 Apr 2016 01:53:07 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030985#M464695 2016-04-14T01:53:07Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030986#M464696 <HTML><HEAD></HEAD><BODY><P>try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">If(GetSelectedCount(Quarter)=0</SPAN><STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">,'$(varCurQtr)',&nbsp; and </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">GetFieldSelections(Quarter))</SPAN></P></BODY></HTML> Thu, 14 Apr 2016 01:55:50 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030986#M464696 Chanty4u 2016-04-14T01:55:50Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030987#M464697 <HTML><HEAD></HEAD><BODY><P>remove quotes to variable and try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">If(GetSelectedCount(Quarter)=0</SPAN><STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">,$(varCurQtr),</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">GetFieldSelections(Quarter))</SPAN></P></BODY></HTML> Thu, 14 Apr 2016 01:57:54 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030987#M464697 Chanty4u 2016-04-14T01:57:54Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030988#M464698 <HTML><HEAD></HEAD><BODY><P><EM>Try as well,</EM></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>If(GetSelectedCount(Quarter)=0,$(varCurQtr),GetFieldSelections(Quarter))</EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>or<BR /></EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><EM>If(GetSelectedCount(Quarter)=0,varCurQtr,GetFieldSelections(Quarter))</EM></SPAN></P></BODY></HTML> Thu, 14 Apr 2016 01:59:43 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030988#M464698 tamilarasu 2016-04-14T01:59:43Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030989#M464699 <HTML><HEAD></HEAD><BODY><P>try this too</P><P></P><P><SPAN style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">If(GetSelectedCount(Quarter)=0</SPAN><STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">,=$(varCurQtr),</STRONG><SPAN style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">GetFieldSelections(Quarter))</SPAN></P></BODY></HTML> Thu, 14 Apr 2016 02:01:32 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030989#M464699 Chanty4u 2016-04-14T02:01:32Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030990#M464700 <HTML><HEAD></HEAD><BODY><P>Hi Subba,</P><P></P><P>Try this:</P><P></P><P>=if=If(GetSelectedCount(Quarter)=0,$(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">varCurQtr</SPAN>),GetFieldSelections(Quarter))</P><P></P><P>Regards,</P><P>Carlos</P></BODY></HTML> Thu, 14 Apr 2016 03:13:36 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030990#M464700 clondono 2016-04-14T03:13:36Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030991#M464701 <HTML><HEAD></HEAD><BODY><P>Sorry I have a typo, typed "=if" twice by mistake, this is the correct one:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=If(GetSelectedCount(Quarter)=0,$(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">varCurQtr</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">),GetFieldSelections(Quarter))</SPAN></P></BODY></HTML> Thu, 14 Apr 2016 03:14:40 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030991#M464701 clondono 2016-04-14T03:14:40Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030992#M464702 <HTML><HEAD></HEAD><BODY><P>Thank You, its working fine.</P></BODY></HTML> Thu, 14 Apr 2016 04:20:03 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030992#M464702 2016-04-14T04:20:03Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030993#M464703 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Thank You, its working fine.</SPAN></P></BODY></HTML> Thu, 14 Apr 2016 04:20:13 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030993#M464703 2016-04-14T04:20:13Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030994#M464704 <HTML><HEAD></HEAD><BODY><P>cooooooool.... please close this thread by making correct and helpfull answers above:)</P></BODY></HTML> Thu, 14 Apr 2016 04:24:16 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030994#M464704 Chanty4u 2016-04-14T04:24:16Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030995#M464705 <HTML><HEAD></HEAD><BODY><P>i did yar</P></BODY></HTML> Thu, 14 Apr 2016 04:29:55 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030995#M464705 2016-04-14T04:29:55Z Re: Correct the expr https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030996#M464706 <HTML><HEAD></HEAD><BODY><P>No reddy.</P><P></P><P>chk below..<IMG alt="thrd.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121608_thrd.PNG" style="height: 360px; width: 620px;" /></P></BODY></HTML> Thu, 14 Apr 2016 04:36:34 GMT https://community.qlik.com/t5/QlikView/Correct-the-expr/m-p/1030996#M464706 Chanty4u 2016-04-14T04:36:34Z