Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

byrnel0586
Contributor

Aggr/Sum totals by Year

Hi,

I am wanting a simple pivot table that aggregates the total sum of the field 'NUM_STATUS' by the dimension 'Year'. I want it to sum the amount for the entire year though, not just the month/year selected. I've created expressions using set analysis to aggr a single year, but don't want to have to create a new expression for each year.

What is appropriate expression to use in order to sum the total of NUM_STATUS for all years regardless of selections?

Thank you.

1 Solution

Accepted Solutions

Re: Aggr/Sum totals by Year

May be this

Sum({<Year, Month, MonthYear>}NUM_STATUS)

4 Replies

Re: Aggr/Sum totals by Year

May be this

Sum({<Year, Month, MonthYear>}NUM_STATUS)

byrnel0586
Contributor

Re: Aggr/Sum totals by Year

Of course, so simple. Thank you!

byrnel0586
Contributor

Re: Aggr/Sum totals by Year

Hi Sunny,

After doing more calculations using this formula I found that it does sum the NUM_STATUS for the whole year, but will change based on other selections such as Name, ID, etc. I am needing to show a total sum of NUM_STATUS by Year regardless of any selection.

Your help is much appreciated!

Re: Aggr/Sum totals by Year

May be this

Sum({1}NUM_STATUS)

Community Browser