topic Re: Combine Data Values in Bar Chart in QlikView https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104121#M901876 <HTML><HEAD></HEAD><BODY><P>Try using like this in your script for [Area ID]...</P><P>pick(match([Area ID],'ASM','BIW','C-2','PNT'),'TCF','BIW','PAINT','PAINT') as <SPAN style="font-size: 13.3333px;">[Area ID]</SPAN></P><P></P><P>or </P><P></P><P style="font-size: 13.3333px;">Try using like this in your dimension for [Area ID]...</P><P style="font-size: 13.3333px;">pick(match([Area ID],'ASM','BIW','C-2','PNT'),'TCF','BIW','PAINT','PAINT') as <SPAN style="font-size: 13.3333px;">[Area ID]</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 06 Jul 2016 16:57:25 GMT vikramv 2016-07-06T16:57:25Z Combine Data Values in Bar Chart https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104119#M901874 <HTML><HEAD></HEAD><BODY><P>I have a dimension "Area ID" which branches into 4 departments: "ASM", "BIW", "C-2", and "PNT"..... I want to REPLACE "ASM" with "TCF", CHANGE "C-2" &amp; "PNT" to "PAINT", and keep "BIW".... Is this possible through an expression? Thanks in advance. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104119#M901874 2020-11-25T16:16:04Z Re: Combine Data Values in Bar Chart https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104120#M901875 <HTML><HEAD></HEAD><BODY><P>May be use a calculated dimension or make changes in the script using if statements:</P><P></P><P>Calculated dimension</P><P><STRONG>If([Area ID] = 'ASM', 'TCF',</STRONG></P><P><STRONG>If(Match([Area ID], 'PNT', 'C-2'), 'PAINT', [Area ID]))</STRONG></P><P></P><P>script:</P><P style="font-size: 13.3333px;"><STRONG>If([Area ID] = 'ASM', 'TCF',</STRONG></P><P style="font-size: 13.3333px;"><STRONG>If(Match([Area ID], 'PNT', 'C-2'), 'PAINT', [Area ID])) as <STRONG style="font-size: 13.3333px;">[Area ID]</STRONG></STRONG></P></BODY></HTML> Wed, 06 Jul 2016 16:21:47 GMT https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104120#M901875 sunny_talwar 2016-07-06T16:21:47Z Re: Combine Data Values in Bar Chart https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104121#M901876 <HTML><HEAD></HEAD><BODY><P>Try using like this in your script for [Area ID]...</P><P>pick(match([Area ID],'ASM','BIW','C-2','PNT'),'TCF','BIW','PAINT','PAINT') as <SPAN style="font-size: 13.3333px;">[Area ID]</SPAN></P><P></P><P>or </P><P></P><P style="font-size: 13.3333px;">Try using like this in your dimension for [Area ID]...</P><P style="font-size: 13.3333px;">pick(match([Area ID],'ASM','BIW','C-2','PNT'),'TCF','BIW','PAINT','PAINT') as <SPAN style="font-size: 13.3333px;">[Area ID]</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 06 Jul 2016 16:57:25 GMT https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104121#M901876 vikramv 2016-07-06T16:57:25Z Re: Combine Data Values in Bar Chart https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104122#M901877 <HTML><HEAD></HEAD><BODY><P>Thanks Again!</P></BODY></HTML> Wed, 06 Jul 2016 17:40:41 GMT https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104122#M901877 2016-07-06T17:40:41Z Re: Combine Data Values in Bar Chart https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104123#M901878 <HTML><HEAD></HEAD><BODY><P>No problem at all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 06 Jul 2016 17:57:03 GMT https://community.qlik.com/t5/QlikView/Combine-Data-Values-in-Bar-Chart/m-p/1104123#M901878 sunny_talwar 2016-07-06T17:57:03Z