topic Re: Back end scripting in QlikView

Back end scripting

sunitha_chellaiah — Mon, 17 Sep 2018 09:09:51 GMT

Hi All,

Please achieve the below outputs with the attached data set through back end scripting only.

Where

Actual Sales Value = Quantity * Price

The below points should be considered while achieving the output.

All outputs to be achieved through back end scripting only. Only Sum() in front end to be used.
Only Straight tables. No Pivots. Only One dimension and three expressions to be used in the chart
No changes to the data set to be made.

swuehl — Mon, 17 Sep 2018 09:28:49 GMT

What's the logic behind the last two columns so we don't need to guess?

sunitha_chellaiah — Mon, 17 Sep 2018 09:48:20 GMT

Sales_Ouput_1 - It is just a cumulative addition(Full Accumulation)

Sales_Output_2 - 2 steps accumulation

Peter_Cammaert — Mon, 17 Sep 2018 10:26:39 GMT

I guess stuff like this is much simpler to accomplish in the front-end (using Above() & friends) than in the back-end.

But anyway, that's not your question. Consider using an AsOf-table. The concept is explained here: The As-Of Table