topic Re: Help: Group BY, AGGR, Join Temp Table in Script? in QlikView

Help: Group BY, AGGR, Join Temp Table in Script?

Mon, 22 Aug 2011 12:00:33 GMT

Hi All,

I am trying to create a temporary table in the Script however i am a little unsure on the best way to go about this. I have attached an excel document that has soem exampel raw data and teh table i would like to create.

Any help would be appreciated.

thanks

dan

Re: Help: Group BY, AGGR, Join Temp Table in Script?

Anonymous — Mon, 22 Aug 2011 13:40:43 GMT

Hi,

See the file attached.

Regards,

Arjan

Help: Group BY, AGGR, Join Temp Table in Script?

Mon, 22 Aug 2011 14:46:38 GMT

Hi Arjan

Thanks for the reply. That looks like it does the trick.

Would it be possible to add a Field to 'DetailStart' called 'Secondreporter1011' and update this (where fy=2010/11) based on the expression 'count(SecondReporter)/count(FirstReporter)'?

Ultimatly what i would like to do is use the 2011/12 ratio as an estimate for 2010/11 as no historical data is available.

Thanks

dan

Re: Help: Group BY, AGGR, Join Temp Table in Script?

Mon, 22 Aug 2011 14:47:03 GMT

Hi Arjan

Thanks for the reply. That looks like it does the trick.

Would it be possible to add a Field to 'DetailStart' called 'Secondreporter1011' and update this (where fy=2010/11) based on the expression 'count(SecondReporter)/count(FirstReporter)'?

Ultimatly what i would like to do is use the 2011/12 ratio as an estimate for 2010/11 as no historical data is available.

Thanks

dan

Re: Help: Group BY, AGGR, Join Temp Table in Script?

Mon, 22 Aug 2011 14:57:48 GMT

HI Arjan

I think i have done what i am trying to do based on your above sample but it would be great if you could take a look and let me know if there is a better way.

Kind regards,

Dan