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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a data show as below, I'm expecting output as below.
Boat 2022 Boat
Apple fruit Apple fruit
Apple fruit 2023 Apple fruit
Apple2fruit 2022 Apple2fruit
p2p 2022 p2p
if it has number(basically the number is year, year can be any year irrespective of what it is showing above) in last four digits it's should not show,
Can anyone please help me on this. thanks in advance.
Assuming year is always separated by empty space:
if(right(field, 1))>=0, left(field,length(field)-5), field) as NewField