Previous month Sales in Script

[preminqlik]

Hi , i want to calculate the previous month sales in script

Please find attachment

can any body help me ..

[Siva_Sankar]

Couldn't able to open your file. Refer the following.

http://community.qlik.com/message/350909#350909

Regards.

Siva

[preminqlik]

i want to caclulate in script level...not in the front end..

[Anonymous]

Prem

Is the attached what you are after ?

Best Regards,     Bill

[preminqlik]

sivasankar hey kamal hasan thanks for sending some thing useful...but i have to calculate in script level....

Bill Markham thanks for looking to my question..am attaching screen shot as per your calculation ... please observe

Many thanks

Prem

[Anonymous]

Prem

If you want to slice and dice it over dimensions then why not do it in the GUI as Siva suggested & gave you the link for.

But if you do have a compelling reason to do it in the script then I would be curious to know what this reason is ?

Best Regards,     Bill

[jerem1234]

To get what you desire in the script, you'll have to order by Item as well:

order by Item, Date;

I would also change your Month field to:

Date(Date, 'MMM YYYY')

so it separates the months by Year also.

Please find attached. However it won't work unless you have an Item selected.

Maybe like Bill and Siva mentions, you could just use an expression in chart.

Maybe an alternative to whats listed is to use the above function in a straight chart?

Please find attached.

Hope this helps!