Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kalyandg
Partner - Creator III
Partner - Creator III

Last 3 Month Sales calculation in Load script

Hi All,

I have the requirement from one of our client. Need to take last 3 months Sales dynamically in script.

If user selects Apr 2018, Jan / Feb / Mar 2018 total sum should be derived and then Avg should be calculated.

Jan 2018 = 500

Feb 2018 = 600

Mar 2018 = 700

Total Sum = 1800

Avg = 1800/3 = 600

Target = 600 * 5%

I need your help in calculating Total sum and Avg of last three months of all selections dynamically.

It should be created in script instead of front end (Set analysis). Because after Avg calc. it will be used for Target calc.

Please help.

Thanks in Advance,

Kalyan

2 Replies
eduardo_dimperio
Specialist II
Specialist II

Well but script is static, not dinamic.

You could make the SUM of all last 3 months of all months to show when your client select one month in chart.

kalyandg
Partner - Creator III
Partner - Creator III
Author

Hi,

How to do "SUM of all last 3 months of all months to show when your client select one month in chart."

please tell me the script logic.