topic For calculating the sum of Net_salesValue up to recent Gl_Period in QlikView

For calculating the sum of Net_salesValue up to recent Gl_Period

sunil2288 — Tue, 13 Jul 2010 07:49:32 GMT

Hi EveryOne,

I have a table having Gl_Period from 1 to 12 and ther is corresponding Net_salesValue,

I need to calculate the sum (Net_salesValue) up to the month 4 when i select Gl_Period 4 ..

Comments Awaited

Thanks

Suneel

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 08:00:51 GMT

Try this:

Instead of sum (Net_salesValue)

Sum({$<Gl_Period= {'Gl_Period 4'}>}Net_salesValue)

Hope this works. I apologies in advance if it doesn't. I'm new to Qlikview

For calculating the sum of Net_salesValue up to recent Gl_Period

sunil2288 — Tue, 13 Jul 2010 08:15:44 GMT

hi blaze,

I want the sum (Net_Salesvalues) up to the current Gl_period i have selected.

Like If i select 4.It will be the sum of (Net_Salesvalues for Gl_period 1+Gl_period 2+Gl_period 3+Gl_period4)

Please helpme out..

Suneel

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 08:25:23 GMT

Oh i see. Then try this

Sum({$<Gl_Period= {'Gl_Period 1';'Gl_Period 2';'Gl_Period 3';'Gl_Period 4'}>}Net_salesValue)

Hope it helps.

For calculating the sum of Net_salesValue up to recent Gl_Period

sunil2288 — Tue, 13 Jul 2010 08:41:18 GMT

hi Blaze,

Thanks for the Quick Reply..but i need it Dynamically...

That is the Gl_Period Should be select by the user..And in Accordance to that the corresponding Sum will be shownout..

Awaiting for response..

Thanks,

Suneel

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 09:21:49 GMT

sorry i cant think of anything but i'll keep trying

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 09:50:47 GMT

Hi Sunil,

Here i have tried a simple form of your requirement. Just like a Hint.

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 09:54:26 GMT

sorry but dont understand?

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 10:00:02 GMT

Sorry, i forgot to explain.

If you select the List Box "DateFormat", based on your selection, the Sum(Value) chart will display the total. Here i have used the date to see the value.

Hope you can understand now, but the dimension need to be checked and validate the formula. Since, it produce "error in calculation" now.

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 10:32:32 GMT

Mr. Sunil,

First of all, you need to have your source (Excel) data in Date format as shown below:

GI Period	Net sales
01-Jan-10	5
01-Feb-10	10
01-Mar-10	15
01-Apr-10	20
01-May-10	25
01-Jun-10	30
01-Jul-10	35
01-Aug-10	40
01-Sep-10	45
01-Oct-10	50
01-Nov-10	55
01-Dec-10	60

For facility to select month you want, define variable e.g. "Upto Date".

Link this variable with the table created in QV.

To get total sales upto selected month, you can tick "show partial sums" in presentation tab.

To get an idea, I have attached QV file.

Hope it will work for you.

Sincere Regards,

RBA

For calculating the sum of Net_salesValue up to recent Gl_Period

raghavsurya — Tue, 13 Jul 2010 11:05:50 GMT

Hi Sunil,

Try giving the expression like

(Sum({<GLPeriod={$(=Max(GLPeriod))}>}(Net_salesValue)) + (Sum({<GLPeriod={$(=Max(GLPeriod)-1)}>} Net_salesValue))) + (Sum({<GLPeriod={$(=Max(GLPeriod)-3)}>}(Net_salesValue)) + (Sum({<GLPeriod={$(=Max(GLPeriod)-4)}>} Net_salesValue)))

This will dynamically pick the latest 4 period values and give you the sum.

Regards,

Raghav

For calculating the sum of Net_salesValue up to recent Gl_Period

sunil2288 — Tue, 13 Jul 2010 11:43:39 GMT

hi Ravi,

I don't have Gl_Period Value in date Format,it is in 1,2,3,4.....12

For calculating the sum of Net_salesValue up to recent Gl_Period

Tue, 13 Jul 2010 12:51:16 GMT

Dear Sunil,

Fine, let your data be in following format.

GI Period	Net sales
1	5
2	10
3	15
4	20
5	25
6	30
7	35
8	40
9	45
10	50
11	55
12	60

You will have to follow same steps as mentioned before.

Only difference will be instead of calendar, create slider having numbers from 1 to 12 (indicating months).

Plz refer to the attachment.

Whichever month number you will choose, Net sales upto that month will be displayed.

I hope this is fine now.

Sincere Regards,

RBA

For calculating the sum of Net_salesValue up to recent Gl_Period

sunil2288 — Wed, 14 Jul 2010 05:24:28 GMT

HI RAB,

Thank you Very much for your continuous mailing..

I got the solution as you described..

Thanks Once again..

Suneel.