topic Re: Data Reload in App Development

Data Reload

denny_wu — Fri, 27 Apr 2018 07:54:16 GMT

Hi There,

I need help from you guys.

i have table something like this:

RecipeKey related with SpecKey. so, i want to add new column (column name is "Key). that Key value should be first row of SpecKey.

how to build that script ?

Thanks

Denny Wu

Re: Data Reload

rubenmarin — Fri, 27 Apr 2018 08:04:10 GMT

Hi Denny, in script you can do a sorted reload and use Peek() to propagate the value:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/InterRecordFunctions/Peek.htm

If(IsNull(Peek('Key')), Description, Peek('Key')) as Key

Usually you need to group values to 'reset' the propagated value, if not all rows will have the same value.

If(GroupCode<>Peek('GroupCode'), Description, Peek('Key')) as Key

Re: Data Reload

denny_wu — Fri, 27 Apr 2018 08:12:11 GMT

What do you mean Group values ?
i dont see can group the values, cause all row is related with column RecipeKey.

Re: Data Reload

rubenmarin — Fri, 27 Apr 2018 09:15:46 GMT

Just that usually the value changes on some conditions, like taking the first value of each year, if you want the same value in all rows it doesn't matter. It was only an example.