How to write a script to define sales for each quarter

Sarath123 — Wed, 25 Sep 2019 11:23:47 GMT

I have the data as attached below.

Lastime I calculated the sales based on the code by taking the sum of sales for the particular code

Now I am trying to caculate the sales for each quarter by using my caculated codes to find them
for code 3101 the sales should be sum of sales(3101)-sales(31010140)-sales(31010160)-sales(31010107)

for code 3201 the sales should be sum of sales (3201)-sales(32010140)-sales(32010160)-sales(32010107)

suppose for quarter Q2 2019 sales for both 3101&3201 should be exchanged with the caculated sales by using the above condition. I don't need the sum of sales instead for each quarter I need the sales value.
Like this I need to change my data for all the quarters (9quarters)with the new calculated values so that I can sum the sales values later
Can someone help me to define that on the script
My final output should be as
code TU_company_QTR TU_Total_QTR quarter year
3101 xxxxxx xxxxxx Q2 2019
3101 xxxxxx xxxxxx Q1 2019
.
.

3101 xxxxxx xxxxxxx Q2 2017
where xxxx will be the new calculated sales by using below condition
3101 should be sum of sales(3101)-sales(31010140)-sales(31010160)-sales(31010107)

Can someone help me to define that on the script

Re: How to write a script to define sales for each quarter

Brett_Bleess — Thu, 03 Oct 2019 21:11:39 GMT

Sarath, try searching in the Design Blog area using the following link, I suspect you will find some useful examples on how to do things that should assist you in figuring things out.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic How to write a script to define sales for each quarter in QlikView

How to write a script to define sales for each quarter

Re: How to write a script to define sales for each quarter