Set Analysis to Script level

[#1]

Hi all,

Can you please help me in converting a set analysis expression to a script level expression?

Expression:

Sum

({$<YEAR = {$(=Max(YEAR))}>} VOLUME)

Any help would be appreciated.

Thanks in advance.

Regards,

Susvith

[jonasheisterkam]

In script you can group and order by year, sum Volume and peek the last. In textbox you can use some expression like sum(if(Year=Max({1}Year),Volume,0))

[Sokkorn]

Hi Susvith,

We cannot use Set Analysis in script level. Set Analysis is use for QlikView object level only. In your case, we can use max in load script; something like:

[Data]:

LOAD

     Max(YEAR)     AS [YEAR],

     VOLUME

Resident...

Again, load max year above is very limit for us to do further analysis. I'm highly recommend use Set Analysis in object level.

Regards,

Sokkorn

[#4]

Thanks for your reply..

Actualy i was struck with different case here. Please go through to the following link.

My problem was explained here.

http://community.qlik.com/thread/98541

Regards,

Susvith