topic Re: Disregard month selection in QlikView

Disregard month selection

Fri, 17 Apr 2015 12:08:10 GMT

Hello!

I want to disregard the month selection and have following formula,

sum({$<Month=>} aggr((Sum(amount_NR)/Sum(Count_nr))*Sum(Count_NB) * Sum(Days) / 7 / Procentamount, Counting_opps,))

Despite that I have {$<Month=>} it still changes data when I select different months. I have loaded a calendar which have month as dimension and is connected to the facts table via Date field.

Need som help so figure this out.

Best regards

Mårten

Re: Disregard month selection

sunny_talwar — Fri, 17 Apr 2015 12:13:43 GMT

Try putting {$<Month =>} for everytime you use Sum in your expression. May be like this:

=Sum({$<Month=>} Aggr((Sum({$<Month=>} amount_NR)/Sum({$<Month=>}Count_nr)) * Sum({$<Month=>}Count_NB) * Sum({$<Month=>}Days) / 7 /Procentamount, Counting_opps))

Re: Disregard month selection

rubenmarin — Fri, 17 Apr 2015 12:13:52 GMT

Hi Marten, you'll need to add the set analisys expression to each of the Sum() inside the Aggr():

sum({$<Month=>} aggr((Sum({$<Month=>} amount_NR)/Sum({$<Month=>} Count_nr))*Sum({$<Month=>} Count_NB) * Sum({$<Month=>} Days) / 7 / Only({$<Month=>} Procentamount), Counting_opps))

Procentamount will be only one value per Counting_opps? If tehree is more than one value it will return null()

Re: Disregard month selection

Fri, 17 Apr 2015 12:28:30 GMT

Great, now it works.

Thanks!

Best regards

Mårten