Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

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

Tags (3)
4 Replies
arjanijlenhave
New Contributor

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

Hi,

See the file attached.

Regards,

Arjan

Not applicable

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

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

Not applicable

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

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

Not applicable

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

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

Community Browser