topic Help required in Set analysis in QlikView

Help required in Set analysis

Wed, 19 Feb 2014 15:32:15 GMT

Hi Folks,

I am trying to do the below set analysis. Can you see if you can help me out.

Here is the main expression

=MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"*********"}>} EmployeeName)

In place of *********, I have to add the below expression.

Max( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"<=$(vCurrentDate)"}>} Date)

How can I do that?

Thanks.

MK_QSL — Wed, 19 Feb 2014 15:36:00 GMT

Create a variable

vVar1 = Max( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"<=$(vCurrentDate)"}>} Date)

Now use

=MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={'$(vVar1)'}>} EmployeeName)

=MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={'$(=vVar1)'}>} EmployeeName)

Wed, 19 Feb 2014 15:46:06 GMT

Hi Manish,

This doesn't work.

I doubt this is because vCurrentDate is again includes another set expression. Listing here all the expressions.

Is max function inside another max function will work in set anaylsis?

Final expression =MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={'$(vVar1)'}>} EmployeeName)

vVar1 = Max( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"<=$(vCurrentDate)"}>} Date)

vCurrentDate = max( { 1 < Date = {'<=$(vToday)'} >}Date)

vDate = =Date(Today(),'MM/DD/YYYY')