Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
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!!
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...
Hi friends...
I was able to solve aplplying the following condition:
=IF(LEN(ZM_PLACA)=7,ZM_PLACA,)
Simplest impossible...
Thanks everybody!!!