topic Re: Referencing a field within a function, within a Set Analysis in QlikView

Referencing a field within a function, within a Set Analysis

Thu, 18 Jul 2013 09:16:19 GMT

Hi,

I have the following expression:

SUM({$<Data.ReportMonth1=, [Report Calendar.FinancialYear]=, MonthYear={"$(=Text(Date(AddMonths(Date#(vReportDate,'MMM YYYY'),MIN(Data.QtrReportAdj)),'MMM YYYY')))"}>}Data.QuarterActual

)

My problem seems to be when I'm trying to adjust the date. From what I can tell is happing, is the MIN(Data.QtrReportAdj) seems to be applying to all my measures, rather than just the measure.

In the example attached, if you filter by the A&E 4 hr target(excludes walk-in centres), it works fine.

Hope this makes sense.

Thank you in advance,

Simon

Re: Referencing a field within a function, within a Set Analysis

luciancotea — Thu, 18 Jul 2013 09:26:53 GMT

Set analysis is evaluated once for all rows, not for each row.

Re: Referencing a field within a function, within a Set Analysis

Thu, 18 Jul 2013 09:36:12 GMT

Hi,

Sorry, but im a bit confused.

If I replace MIN(Data.QtrReportAdj) with -3, I get the answer for each measure, so the Set analysis works for each row. I dont get the sum off all measures.

Can you expand on what you mean

Cheers

Re: Referencing a field within a function, within a Set Analysis

Thu, 18 Jul 2013 09:36:33 GMT

Hi,

Sorry, but im a bit confused.

If I replace MIN(Data.QtrReportAdj) with -3, I get the answer for each measure, so the Set analysis works for each row. I dont get the sum off all measures.

Can you expand on what you mean

Cheers

Re: Referencing a field within a function, within a Set Analysis

luciancotea — Thu, 18 Jul 2013 09:47:53 GMT

Again, MIN(Data.QtrReportAdj) is evaluated once and the evaluation = -6.

You can see the expression evaluation result if you remove the label of the expression. See attachment.

Re: Referencing a field within a function, within a Set Analysis

simondachstr — Thu, 18 Jul 2013 10:27:23 GMT

I think at this point you will need to introduce min(Data.QtrReportAdj) as new field in your data model.