topic Question about set analysis in QlikView

Question about set analysis

Tue, 02 Feb 2010 09:39:01 GMT

Hi,

I confused about set anlysis function. It's powerful.However If I want to write a expression include dimentions, the result is confusing.

Here is a example,

I want to get build a chart with Year as dimention and return first month and last month sales every year?

How to do it?

I had wrote a qvw in attachment, Pls help me to get it out.

Miguel_Angel_Baeyens — Tue, 02 Feb 2010 10:22:14 GMT

Hello,

You should use syntax like

sum({<YearMonth = {"$(=min(YearMonth))"}>} sales)

in any case. Dollar expansion in set analysis is always

$(=Function())

as the example above. Hope this helps.

Tue, 02 Feb 2010 11:07:48 GMT

Thanks, you are right.

I just to try to use relative to the "year" dimention. It seems it only return one correct result.

How to deal this ?