I need to clean one column so the Qlik Sense so it shows only valid data

[#1]

Hi my friends

In my table i have one field called PLACA, this field have a format of character and should be filled as follows: AAA0123 (it´s just one exemplo)

However some users fill with garbage, "aaaaaaa", "/ \ / \", "! @ # $%" and others ...
I need to apply to this column in Qlik Sense a function that initially only displays fields that contain 7 characters.

How to make this?

[rittermd]

Do you want to eliminate those rows from coming into your App or do you want to modify them or mark them as invalid once in your app?

[#3]

I wish Qlik Sense just ignored them.

Due to the format of our system operation, I can not prevent the user from entering the wrong way...The correct would be to prevent this, but it is not possible!

Thanks!!

[MK9885]

If you are sure the values should only be AAA then use if condition with Wildmatch to eliminate others?

if (wildmatch(PLACA , 'AAA*')>0,'YourOwnValueHere',

if (wildmatch(PLACA , 'BBB*')>0,'YourOwnValueHere',

if (wildmatch(PLACA , 'CCC*')>0,'YourOwnValueHere', PLACA)

Not sure if the expression is correct but Wildmatch should work if you do not have more values...

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ConditionalFunctions/w...

[#5]

Hi friends...

I was able to solve aplplying the following condition:

=IF(LEN(ZM_PLACA)=7,ZM_PLACA,)

Simplest impossible...

Thanks everybody!!!