Quick Set Analysis question

alexis — Mon, 18 Feb 2013 09:08:35 GMT

In a previous post I asked a fairly difficult to understand question but looking at the question and the responses it occured to me that the problem (and the answer hopefully) are simpler:

I have a variable that contains the following definition:

{$<MonthID = {">=$(=min(MonthID) - 12)"},

Date = {"<$(=Date(MakeDate(Year(Max(Date))-1, Month(Max(Date))+1, 1),'DD/MM/YYYY'))"},

Year = ,

Quarter = ,

Period = ,

[Period (#)] = ,

Month = >}

I need to modify if to:

a) Remove the dependency on Date (line 2)

b) Extend the MonthID line (line1) to also include "< max(MonthID) -11"

Conceptually it will look something like:

{$<MonthID = {">=$(=min(MonthID) - 12)"} and {"<$(=max(MonthID) - 11)"},

Date = ,

Year = ,

Quarter = ,

Period = ,

[Period (#)] = ,

Month = >}

Your help will be very much appreciated.

Best regards

Alexis

Re: Quick Set Analysis question

Gysbert_Wassenaar — Mon, 18 Feb 2013 09:10:16 GMT

Like this:

MonthID = {">=$(=min(MonthID) - 12)<$(=max(MonthID) - 11)"}

topic Re: Quick Set Analysis question in QlikView

Quick Set Analysis question

Re: Quick Set Analysis question