topic Scripting in App Development

Scripting

niranjana — Wed, 22 Dec 2021 08:40:43 GMT

Hi All,

I have a requirement wherein I have to multiply Units of Current Month Year (ex: Jan20) with Price of Previous month year(ex: Jan 19) in qliksense script. How to do that?

Thanks in advance!

Re: Scripting

jmartineze — Thu, 23 Dec 2021 13:29:55 GMT

Hi,

you can use the previous() function with order by statement.

Re: Scripting

niranjana — Fri, 24 Dec 2021 12:53:23 GMT

NO, I dont think it would work. Previous function is for previous record. But I have data for ex. from Jan 19 to Dec 20. I want sales from Jan 20 to Dec 20 multiplied by units from Jan 19 to Dec 19.ANy help is appreciated.

Thanks