topic function inside set analysis inside another set analysis in QlikView

function inside set analysis inside another set analysis

Thu, 19 Jan 2012 15:41:29 GMT

Hello,

I need to have something like this:

count({<DATE1={"=aggr(max({<DATE1={"=Date(Max({<DATA_TYPE={"DataType1"}>} DATE1))"}>} DATE1),YEAR)"}>}DATE1)

I need this to get the maximum date of a certain data type for a given year.

My problem is I have "" inside another set of "" and it messes the expression.

Is there any escape character to do this?

Best regards.

nstefaniuk — Thu, 19 Jan 2012 16:05:50 GMT

Can you use variables as workaround ?

swuehl — Thu, 19 Jan 2012 16:20:14 GMT

I am little confused by your second search expression, shouldn't something like

=count({<DATA_TYPE={DataType1}, DATE1={"=aggr(max({<DATA_TYPE={DataType1}>} DATE1) ,YEAR)"}>} DATE1)

not be enough?

Thu, 19 Jan 2012 16:23:21 GMT

No...

nstefaniuk — Fri, 20 Jan 2012 07:45:54 GMT

I don't know if the No is for me or swuehl.

Try this:

create a variable vDataType1Date:

=Date(Max({<DATA_TYPE={"DataType1"}>} DATE1))

Then a variable vYearDateMax:

=aggr(max({<DATE1={"$(vDataType1Date)"}>} DATE1),YEAR)

and here is your expression:

=count({<DATE1={"$(vYearDateMax)"}>}DATE1)

Just do it by step to take care of date format.