For calculating the sum of Net_salesValue up to recent Gl_Period

[sunil2288]

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

[#2]

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

[sunil2288 · Accepted solution]

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

[#4]

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.

[sunil2288]

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

[#6]

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

[#7]

Hi Sunil,

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

[#8]

sorry but dont understand?

[#9]

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.

[#10]

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