Discussion board where members can get started with Qlik Sense.
Got a new question going slightly beyond the question I asked in the morning.
Assume the table I am referring looks as below,
This time I want to filter the data based on the below requirements;
1. Select the last two characters of the Item_Code.
2. I want to Flag/Filter the Item_Codes which ONLY got "CD" letters at the END.
Item_Code could just "CD" or it could be the last two letters of a text value.
The out put should be something like below,
Could anyone help me with the above task, would be greatly appreciated.
I used the below command but it did not give me the correct answer,
If(Right(Item_Code,2)= 'NC',1,0) as Flag
Could you please correct me on the above statement?
Thanks in advance
If(Right(Item_Code,2)='CD',1,0) as Flag;
Load * Inline [
Its working Andy. Where do you find issue?