topic How to combine 2 values in dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247590#M856267 <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/152670_highst_1.png" style="height: auto;" /></P><P>1) Here 5 values(EAST,North,South,Unknown,West) are </P><P>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>i attache QVW file&nbsp; and Excel file also</P><P>please give reply...</P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ramrongala 2020-11-25T16:16:04Z How to combine 2 values in dimension https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247590#M856267 <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/152670_highst_1.png" style="height: auto;" /></P><P>1) Here 5 values(EAST,North,South,Unknown,West) are </P><P>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>i attache QVW file&nbsp; and Excel 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/1247590#M856267 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/1247591#M856268 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P>LOAD </P><P>IF(Match(Region, 'Unknown'), 'EAST', Region) AS Region,</P><P>sales</P><P>FROM </P><P><C></C></P><P>(ooxml, embedded labels, table is Sheet1);</P></BODY></HTML> Thu, 09 Feb 2017 19:16:43 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247591#M856268 vishsaggi 2017-02-09T19:16:43Z Re: How to combine 2 values in dimension https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247592#M856269 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Thanks...working fine</SPAN></P></BODY></HTML> Thu, 09 Feb 2017 19:28:00 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-values-in-dimension/m-p/1247592#M856269 ramrongala 2017-02-09T19:28:00Z