Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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

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?

4 Replies
rittermd
Honored Contributor

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

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?

Not applicable

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

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!!

Khan_Mohammed
Honored Contributor II

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

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...

Not applicable

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

Hi friends...

I was able to solve aplplying the following condition:

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


Simplest impossible...


Thanks everybody!!!