topic Re: How to combine 2 values in dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247456#M856292 <HTML><HEAD></HEAD><BODY><P>Best is to do it in the script:</P><P>Directory;</P><P>LOAD <STRONG>if(Region='Unknown','EAST', Region) as Region ,</STRONG></P><P>&nbsp;&nbsp;&nbsp;&nbsp; sales</P><P>FROM</P><P><C></C></P><P>(ooxml, embedded labels, table is Sheet1);</P></BODY></HTML> Thu, 09 Feb 2017 19:05:03 GMT Anonymous 2017-02-09T19:05:03Z How to combine 2 values in dimension https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247454#M856290 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I want add 2 values into single value in dimension.</P><P><IMG alt="highst_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152669_highst_1.png" style="height: auto;" /></P><P>1) Here 5 values(EAST,North,South,Unknown,West) are there but i want add 'Unknown' and 'EAST' into&nbsp; single value like 'EAST'&nbsp; then sum of sales also automatically show single value right.how to combine</P><P>2) How to display Highest value in sum(sales) and corresponding Region also.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; i am using Aggr() it show only highest value but not Region&nbsp; </P><P></P><P> i attache QVW file also</P><P>please give reply...</P><P>Thanks </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247454#M856290 ramrongala 2020-11-25T16:16:04Z Re: How to combine 2 values in dimension https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247455#M856291 <HTML><HEAD></HEAD><BODY><P>I think there is no data in your attached app. Can you reload and repost your app?</P></BODY></HTML> Thu, 09 Feb 2017 19:04:30 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247455#M856291 sunny_talwar 2017-02-09T19:04:30Z Re: How to combine 2 values in dimension https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247456#M856292 <HTML><HEAD></HEAD><BODY><P>Best is to do it in the script:</P><P>Directory;</P><P>LOAD <STRONG>if(Region='Unknown','EAST', Region) as Region ,</STRONG></P><P>&nbsp;&nbsp;&nbsp;&nbsp; sales</P><P>FROM</P><P><C></C></P><P>(ooxml, embedded labels, table is Sheet1);</P></BODY></HTML> Thu, 09 Feb 2017 19:05:03 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247456#M856292 Anonymous 2017-02-09T19:05:03Z Re: How to combine 2 values in dimension https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247457#M856293 <HTML><HEAD></HEAD><BODY><P>Ok Bro</P></BODY></HTML> Thu, 09 Feb 2017 19:09:00 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247457#M856293 ramrongala 2017-02-09T19:09:00Z Re: How to combine 2 values in dimension https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247458#M856294 <HTML><HEAD></HEAD><BODY><P>Thanks...working fine</P></BODY></HTML> Thu, 09 Feb 2017 19:27:04 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247458#M856294 ramrongala 2017-02-09T19:27:04Z