topic Re: Calculate sum based onCurrent selection date. in QlikView

Calculate sum based onCurrent selection date.

Thu, 03 Oct 2013 10:13:46 GMT

Hi,

I wanted to get sum of amount that is transacted in less than or equal to current selection date in a bar chart. My selection is based on Month name. Can anyone help me out

Regards,

Prajna

Re: Calculate sum based onCurrent selection date.

tresB — Thu, 03 Oct 2013 10:22:48 GMT

Try something like:

Sum({<Date={"<=$(Max(Date))"}>}Amount) // assuming Date field is there. Otherwise there would be couple of things to be careful of, like if you want single year data or all the months from last years as well; date format. Best would be if you could share sample app.

Re: Calculate sum based onCurrent selection date.

Thu, 03 Oct 2013 10:30:31 GMT

selection field has only month name and year. year (2011,2012,2013) and month name from Jan to dec.

Ex: If I select year= 2011 and month name = 'Apr''

Then I want sum of amt from Jan to Apr for year 2011

Re: Calculate sum based onCurrent selection date.

tresB — Thu, 03 Oct 2013 10:35:54 GMT

Then try:

Sum({<Month={"<=$(Max(Month))"}>}Amount) // If month is created in the script using month() function, it should work.

Re: Calculate sum based onCurrent selection date.

Thu, 03 Oct 2013 10:37:55 GMT

Hi,

I tried with a key that I had created for month table it worked

Thank you

Prajna

Re: Calculate sum based onCurrent selection date.

Thu, 03 Oct 2013 10:44:48 GMT

use this expression ,its working fine.

sum({<datefield={"<=$(=only(datefield))"}>}amount)

if u need to use upto current date,if u have year ,quarter ,month fields then use below condition

sum({<datefield={"<=$(=only(datefield))"},year=,quarter=,month= >}amount)

this expression gives up to current month

Re: Calculate sum based onCurrent selection date.

Thu, 03 Oct 2013 12:07:53 GMT

hi,

year, quarter and month are these referring to same date field?

I mean I have year and month_name taken from two different fields..so this is not working for me I am getting common value for all selection

can u just telling the use of only?

Re: Calculate sum based onCurrent selection date.

Thu, 03 Oct 2013 12:16:56 GMT

only function refer ,current selection value

let us suppose

year=2000,2001,2002,.....

if u select 2000 ,then only(year)=2000