topic Display sum value based on current month in QlikView

Display sum value based on current month

Fri, 15 Aug 2014 20:51:42 GMT

I have a data set where the fields are netaddresses, MonthAddress, YearAddress. I would like to have a text object show the sum of the netaddresses column but only show values for the current month. I have another list box that already is limiting the data by year but I want the text object to the sum of the current month using the year selected. How would I do that?

Re: Display sum value based on current month

aveeeeeee7en — Fri, 15 Aug 2014 21:36:22 GMT

For current Month you need to use Month(Today()) and Year(Today()) in your expression.

Try this:

='Current Month '&'('&Month(Today())&' - '&Year(Today())&')'&' Amount :'&chr(32)&chr(32)& Sum({<New_Month={'$(=Month(Today()))'},New_Year={'$(=Year(Today()))'}>}Amount)

Also, see the expression for understanding.

Regards

Aviral Nag

Re: Display sum value based on current month

Fri, 15 Aug 2014 21:39:57 GMT

Thanks for the reply. I already have a list box to select the year, however I would only like the have the text object sum the netaddress values for the same current month. Is that possible as I don't want to have to include the year in the expression?