Solved: Sum of 12 months irrespective of selection - Qlik Community

Anonymous · ‎2017-03-16

HI,

I have a database that contains information of several years in a monthly basis, latest is Jan 2017 for Sales and full year for Budget 2017, in a text object I am trying to show the full year value of whatever year budget, but when I select one month or more months i got the value of that specific month or if I select more months then I got the sum of those periods.

What I would like to achieve is to get the full year budget irrespective of the selection of a particular year.

Please

Gysbert_Wassenaar · ‎2017-03-16

You can use set analysis expressions to ignore certain selections. Suppose you have a year field called Year and a month field called Month. And you have an expression sum(Amount). To make the expression ignore selections in the Month field you change it to sum({<Month=>}Amount). See A Primer on Set Analysis for more information.

talk is cheap, supply exceeds demand

View solution in original post

Gysbert_Wassenaar · ‎2017-03-16

You can use set analysis expressions to ignore certain selections. Suppose you have a year field called Year and a month field called Month. And you have an expression sum(Amount). To make the expression ignore selections in the Month field you change it to sum({<Month=>}Amount). See A Primer on Set Analysis for more information.

talk is cheap, supply exceeds demand

Anonymous · ‎2017-03-17

Thank Gysbert, it worked

Cheers