Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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.
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
sorry i cant think of anything but i'll keep trying
Hi Sunil,
Here i have tried a simple form of your requirement. Just like a Hint.
sorry but dont understand?
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.
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