topic Re: How do i create a field from another @ script level in QlikView

How do i create a field from another @ script level

Sun, 28 Sep 2014 14:02:17 GMT

Hello,

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

Plz find attached.

Regards

Ema

Re: How do i create a field from another @ script level

veidlburkhard — Sun, 28 Sep 2014 15:32:55 GMT

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

Re: How do i create a field from another @ script level

senarath — Sun, 28 Sep 2014 16:52:14 GMT

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

Re: How do i create a field from another @ script level

MarcoWedel — Sun, 28 Sep 2014 17:18:53 GMT

alternative in front end?:

<<Snapshot deleted on request of the OP>>

hope this helps

regards

Marco

Re: How do i create a field from another @ script level

MarcoWedel — Sun, 28 Sep 2014 18:00:27 GMT

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