Set Analysis : using conditions

Wed, 20 Jan 2010 09:44:52 GMT

Hi !

I noticed that sometimes

[CODE]
=sum({$<Year=,Month=>} if(Year=$(=Year) and Month=$(=Month), [MyField]))
[/CODE]

doesn't give the same result than

[CODE]
=sum({$} [MyField])
[/CODE]

where "Year" and "Month" are in the selection.

I would like to know how I can use complex conditions in the set analysis statement.

I would like to use a "lower than" and "greater than" and variables and functions.

For instance, I would like to say "only take the values where the date is between a specific date (the selection) and today".

Something like :

[CODE]
=sum({$<Year=,Month=,Day=,Date={">=" & makedate($(=Year), $(=Month), $(=Day)) & "<=" today()}> [MyField])
[/CODE]

Unfortunately, the usage of "&" for the concatenation doesn't seems to work, neither the usage of a function like "makedate" 😞

Even when I set hard values, it doesn't work :

[CODE]
=sum({$<Year=,Month=,Day=,Date={">2008-01-01<2010-01-01"}> [MyField])
[/CODE]

Wed, 20 Jan 2010 10:12:13 GMT

Hi,

here are an example for a date range.

Good luck!

Rainer

Wed, 20 Jan 2010 11:42:01 GMT

The formula in your document is quite the same that the formula I used... but it works

This makes me feel like crazy...

(big thank you )

topic Set Analysis : using conditions in QlikView