topic Re: How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition in App Development

How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

vish123 — Mon, 18 Apr 2022 15:27:04 GMT

Hi Team,

I am loading data from excel and one of the column is Date. But it also contains some text values. so just want to load only dates and ignore text values.

Is there any function or logic to filter only dates?

Re: How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

vchuprina — Mon, 18 Apr 2022 15:58:45 GMT

Hi,

Maybe you can use KeepChar function in the example below it loads only numerical symbols

KeepChar ( YourField, '1234567890' )

Regards,

Vitalii

Re: How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

vish123 — Tue, 19 Apr 2022 09:18:55 GMT

Hi Vchprina,

I have tried above formula and but it did not work for me. Is there any other way?

Re: How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

vchuprina — Tue, 19 Apr 2022 09:44:21 GMT

Could you please share an example of your data?

Re: How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

vish123 — Tue, 19 Apr 2022 10:06:13 GMT

Hi Vchuprina,

Sorry, I cannot share the data as it is confidential.

Re: How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

vchuprina — Tue, 19 Apr 2022 11:07:33 GMT

Can you send the structure of your field, for instance:

some text yyyy/mm/dd, some text

yyyy/mm/dd, some text, numeric values (but not date)

I try to understand how it looks

Re: How to filter on date column and only extract dates and not text in Qlik Sense Script editor using where condition

anat — Tue, 19 Apr 2022 11:52:32 GMT

If( Len(Num(Field))=5 , 'Date', 'String')