topic Previous month Sales in Script in QlikView

Previous month Sales in Script

preminqlik — Fri, 03 Jan 2014 14:13:55 GMT

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

Please find attachment

can any body help me ..

Siva_Sankar — Fri, 03 Jan 2014 14:24:22 GMT

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

Regards.

Siva

preminqlik — Fri, 03 Jan 2014 14:30:19 GMT

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

Anonymous — Fri, 03 Jan 2014 14:40:16 GMT

Prem

Is the attached what you are after ?

Best Regards, Bill

preminqlik — Fri, 03 Jan 2014 18:08:40 GMT

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 — Fri, 03 Jan 2014 18:16:10 GMT

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 — Fri, 03 Jan 2014 18:31:32 GMT

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!