topic Set Analysis to Script level in QlikView

Set Analysis to Script level

Mon, 11 Nov 2013 07:58:28 GMT

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

Re: Set Analysis to Script level

jonasheisterkam — Mon, 11 Nov 2013 08:03:57 GMT

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))

Re: Set Analysis to Script level

Sokkorn — Mon, 11 Nov 2013 08:08:35 GMT

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

Re: Set Analysis to Script level

Mon, 11 Nov 2013 08:13:20 GMT

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