# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

## Ignore selection in an Aggr function

Hi,

can someone assist me , i have the following expression i want it to ignore the year and month selection:

Where should i put the year and month dimension , ive been trying for long .

SUM((aggr(sum([Quantity On Hand])*sum([Unit Cost]),WareHouse,InventoryStockCode)))

5 Replies
Highlighted
MVP & Luminary

## Re: Ignore selection in an Aggr function

Hi,

Try this

SUM((aggr(sum({<Year = ,Month = >}[Quantity On Hand])*sum({<Year = ,Month = >}[Unit Cost]),WareHouse,InventoryStockCode)))

Regards,

Kaushik Solanki

Regards,
Kaushik
Highlighted
MVP

## Re: Ignore selection in an Aggr function

Just to be safe, I would add set analysis to the first Sum as well

Sum({<Year, Month>}Aggr((Sum({<Year, Month>}[Quantity On Hand])*Sum({<Year, Month>}[Unit Cost])), WareHouse, InventoryStockCode))

Highlighted
Not applicable

## Re: Ignore selection in an Aggr function

Hi Sunny

Thanks your suggestion worked fine ....You are a star !!!!

Regards

Innocent

Highlighted
MVP

## Re: Ignore selection in an Aggr function

I am glad I was able to help, please close this thread if you got what you were looking for by marking correct and helpful answers. Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks,

Sunny

Highlighted
Partner

## Re: Ignore selection in an Aggr function

Hi Sunny,

Thanks for the above solution. It helped me to ignore selection while doing AGGR() Function.

Regards,