topic Re: Wildmatch on dates in two fields in QlikView

Wildmatch on dates in two fields

sibrulotte — Fri, 17 Jul 2015 14:35:52 GMT

Hi,

if a date selected in the field [Date_calcul] exists in all of the values in [Date calcul] I'd like a 'Yay'.

Here a re my miserably failing attempts as of now

(and yes both dates exists in the form 2015-07-13 00:00:00)

=if(wildmatch5([Date calcul],only([Date_calcul])),'yay','nay')

gives

'nay'

=if(wildmatch5([Date calcul],'*$(=only([Date_calcul]))*'),'yay','nay')

gives

'nay'

EDIT:

=if(wildmatch5(concat(distinct [Date calcul],'|'),'*$(=only([Date_calcul]))*'),'yay','nay')

Gives me 'yay'

figured it out before pressing Post, but I figured I'd share for common knowledge

MK_QSL — Fri, 17 Jul 2015 14:41:09 GMT

is wildmatch5() still exists?

sibrulotte — Fri, 17 Jul 2015 15:06:38 GMT

Yes,

Working on QV 11.20.12235 SR5

MK_QSL — Fri, 17 Jul 2015 15:07:55 GMT

sibrulotte — Fri, 17 Jul 2015 15:13:30 GMT

Both