Scripting

[niranjana]

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!

[jmartineze]

Hi, 

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

[niranjana]

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