This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a field consisting of below values
Here I want to group only A , B and C together and called it as 'Group1' and want to keep D as it is and the value E should not appear in the final output as shown below:-
Can you please help me achieve this?
try below one
load *, If(Field1='A' Or Field1='B' Or Field1='C','Group1', if(Field1='D','D')) as New_Field;
load * inline
View solution in original post
Can u try using applymap by creating mapping table
Hi Sasikant and Anat...
Both the solutions are working as expected...