topic Re: Last year Sales in Script in QlikView

Last year Sales in Script

alexandermllr — Mon, 20 Mar 2017 09:08:36 GMT

Hello,

i want something like this:

if(Year = '2017',Price*Percent,Price) as New_Price

If the Year is '2017' it should take the Price from Year = '2016' and so on...

Always the last year Price.

Thank you

sarvesh — Mon, 20 Mar 2017 09:12:51 GMT

Try this:

For last Year:-= =Sum({$<Year={$(=Max(Year)-1)}>}Sales)

Regard's

Sarvesh Srivastava

sunny_talwar — Mon, 20 Mar 2017 09:28:56 GMT

May be look into The As-Of Table