topic Re: set analysis with wildmatch in QlikView

set analysis with wildmatch

polisetti — Thu, 07 Aug 2014 07:30:12 GMT

Hi,

I have a set analysis where i have to match an id. The expression is supposed to be like this:

max({<source=wilmatch(source,'*R*'>} date)

basically I want the max date with source having the letter R.

Please give the syntax for this. Please donot suggest using IF. Have other complications too.

Regards

kaushiknsolanki — Thu, 07 Aug 2014 07:33:47 GMT

HI,

Try this.

Max({<Source = {"*R*"}>}Date)

Regards,

Kaushik Solanki

MK_QSL — Thu, 07 Aug 2014 07:47:46 GMT

=Date(Max({<source = {"*R*"}>}date))