How do i create a field from another @ script level

[#1]

Hello,

How can I pull specific data from a field to another fields on certain condition?

Plz find attached.

Regards

Ema

[veidlburkhard]

Hi Emac4444,

seems you tried set analysis in your script. This is not possible. Set analysis is used in the UI, only. I describes the setting of selections.

To get some idea of how to sum in script, please read this:

Qlikview – Moving Expressions to the Load Script | resultdata

hope this helps

Burkhard

[senarath]

Hi Amac,

I think you are trying to get something which could be handled by preceding load function in script.

So please follow below link.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

http://qlikviewcookbook.com/2009/12/simplify-with-preceding-load/

Thanks

[MarcoWedel]

alternative in front end?:

<<Snapshot deleted on request of the OP>>

hope this helps

regards

Marco

[MarcoWedel]

at script level you have to aggregate with sum and use "group by" in your load. Set analysis can only be used in front end expressions:

<<Snapshot deleted on request of the OP>>

hope this helps

regards

Marco