Hi!
This code generates the first bar chart which is almost perfect. I want to combine two of the values, 'SpecialOctave' and 'OverloadSoundTestAdder'. See below.
let vChrs = chr(32)&chr(160)&chr(10)&chr(13)&chr(9);
if(isnull([Sound Test_WESSOUNDTEST Description]),
'None',
purgechar([Sound Test_WESSOUNDTEST Description],'$(vChrs)')) as [WESSOUNDTEST_Consolidated],
![original_soundtest.JPG original_soundtest.JPG](https://community.qlik.com/t5/image/serverpage/image-id/49394iC1ACE88C74AFFF19/image-size/large?v=v2&px=999)
Here's the code I wrote to combine the values and the result I'm getting which is NOT what I want. Any thoughts? Source data is attached.
let vChrs = chr(32)&chr(160)&chr(10)&chr(13)&chr(9);
if(isnull([Sound Test_WESSOUNDTEST Description]),
'None',
if(match(purgechar([Sound Test_WESSOUNDTEST Description],'$(vChrs)'),'SpecialOctave','OverloadSoundTestAdder'),
'SpecialOctave_OverloadSoundTestAdder',
sound_test_tmp
)
) as [WESSOUNDTEST_Consolidated],
![update_soundtest.JPG update_soundtest.JPG](https://community.qlik.com/t5/image/serverpage/image-id/49395i8CB1DB33E178CBD8/image-size/large?v=v2&px=999)
“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.” — Antoine de Saint-Exupéry