topic Re: Getting Stuck with IF Condition in QlikView https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64053#M789601 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Why did&nbsp; you use "*"&nbsp; before Region?</P><P></P><P>Could you please explain ?</P></BODY></HTML> Thu, 08 Feb 2018 18:56:11 GMT alis2063 2018-02-08T18:56:11Z Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64044#M789590 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need your help, I have three region INDIA,NA,US. i want to show INDIA &amp; NA data in hundred(two or three digits) and US data in thousands(45000)&nbsp;&nbsp; for that i am trying below expression but its not working.</P><P></P><P>=IF(Region='US',Sum(Value),Sum(Value)/1000)</P><P></P><P>please help me ..</P><P>Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64044#M789590 Anonymous 2020-11-25T16:16:04Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64045#M789591 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Could you please explain the context? Are you trying this in a chart or in textbox or the script?</SPAN></P></BODY></HTML> Wed, 07 Feb 2018 07:18:46 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64045#M789591 tresB 2018-02-07T07:18:46Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64046#M789592 <HTML><HEAD></HEAD><BODY><P>In chart</P></BODY></HTML> Wed, 07 Feb 2018 07:20:33 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64046#M789592 Anonymous 2018-02-07T07:20:33Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64047#M789593 <HTML><HEAD></HEAD><BODY><P>Could you share a sample?</P></BODY></HTML> Wed, 07 Feb 2018 07:21:56 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64047#M789593 tresB 2018-02-07T07:21:56Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64048#M789594 <HTML><HEAD></HEAD><BODY><P>sorry, i can't share.</P></BODY></HTML> Wed, 07 Feb 2018 07:34:41 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64048#M789594 Anonymous 2018-02-07T07:34:41Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64049#M789595 <HTML><HEAD></HEAD><BODY><P>Can you share a screenshot of the chart and the expression you are using (that is not working)?</P></BODY></HTML> Wed, 07 Feb 2018 07:53:38 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64049#M789595 tresB 2018-02-07T07:53:38Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64050#M789596 <HTML><HEAD></HEAD><BODY><P>If Region is not one of your dimension, then may be try this</P><P></P><P><STRONG>Sum({&lt;Region *= {'US'}&gt;}Value) + Sum({&lt;Region -= {'US'}&gt;}Value)/1000</STRONG></P></BODY></HTML> Wed, 07 Feb 2018 13:11:40 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64050#M789596 sunny_talwar 2018-02-07T13:11:40Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64051#M789597 <HTML><HEAD></HEAD><BODY><P>Thanks sunny , its working but the issues is it change the whole US value.</P></BODY></HTML> Thu, 08 Feb 2018 04:59:28 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64051#M789597 Anonymous 2018-02-08T04:59:28Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64052#M789599 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny its working now..<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 08 Feb 2018 05:12:09 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64052#M789599 Anonymous 2018-02-08T05:12:09Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64053#M789601 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Why did&nbsp; you use "*"&nbsp; before Region?</P><P></P><P>Could you please explain ?</P></BODY></HTML> Thu, 08 Feb 2018 18:56:11 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64053#M789601 alis2063 2018-02-08T18:56:11Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64054#M789602 <HTML><HEAD></HEAD><BODY><P>It is explained in detail here</P><P><A href="https://community.qlik.com/qlik-blogpost/4663">Implicit Set Operators</A></P></BODY></HTML> Thu, 08 Feb 2018 18:58:10 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64054#M789602 sunny_talwar 2018-02-08T18:58:10Z Re: Getting Stuck with IF Condition https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64055#M789603 <HTML><HEAD></HEAD><BODY><P>Thanks buddy <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 08 Feb 2018 19:06:21 GMT https://community.qlik.com/t5/QlikView/Getting-Stuck-with-IF-Condition/m-p/64055#M789603 alis2063 2018-02-08T19:06:21Z