topic Re: Doubt with set analysis with max(date) in QlikView

Doubt with set analysis with max(date)

Wed, 11 Feb 2015 17:44:58 GMT

Im using this expression

IF(FLAG = '1', sum ({<MonthYear= {'$(=Max(MonthYear))'} >} FLAG))

I wanna see this graphic only with MAX (MONTHYEAR)

it doesn't work i don't know why

Greetings

Re: Doubt with set analysis with max(date)

Wed, 11 Feb 2015 18:04:53 GMT

Would it be okay to share your app?

Re: Doubt with set analysis with max(date)

saurabh5 — Wed, 11 Feb 2015 19:24:03 GMT

Hi Jeremias,

The Monthyear field is a derived field?, if so you can add date function max(date(monthyear)),See if it works.

Regards

Saurabh

Re: Doubt with set analysis with max(date)

consenit — Wed, 11 Feb 2015 19:53:45 GMT

Hi there.

Does the expression work if you hard-code the desired value, for example:

IF(FLAG = '1', sum ({<MonthYear= {'Jan-2015'} >} FLAG))?

If yes, then clearly it'is a formatting problem, try someting like DATE(MAX(MonthYear), 'MMM-YYYY').

Kind regards,

Ernesto.

Re: Doubt with set analysis with max(date)

maxgro — Wed, 11 Feb 2015 20:08:44 GMT

maybe (replace MMM-YYYY with your format)

IF(FLAG='1',

sum({$ <MonthYear={"$(=date(max(MonthYear),'MMM-YYYY'))"}> } FLAG)

)

not sure if the expression IF(FLAG='1', sum( ..... FLAG)) makes sense

Re: Doubt with set analysis with max(date)

krishna20 — Thu, 12 Feb 2015 05:56:38 GMT

Hi,

Sum(Flag) is not correct approach in my point of view.It will be count or you need to take ant other filed in the place of Flag.

Regards

Krishna

Re: Doubt with set analysis with max(date)

PrashantSangle — Thu, 12 Feb 2015 06:13:48 GMT

Hi,

Try like,

IF(FLAG = '1', sum ({<MonthYear= {'$(=Max(MonthYear))',FLAG={'1'}} >} FLAG))

Regards

Re: Doubt with set analysis with max(date)

jagan — Thu, 12 Feb 2015 08:00:12 GMT

Hi,

If you have Monthyear field in this format MMM-YYYY then arrive a date field in your script

Data:

LOAD

Date(Date#(MonthYear, 'MMM-YYYY')) AS Date

FROM DataSource;

Now in chart you can try this expression

Sum ({<FLAG={1}, MonthYear=, Date={'>=$(=MonthStart(Max(Date)))<=$(=Date(Max(Date)))'} >} FLAG)

Regards,

Jagan.