topic Re: calculation should exclude everything except in QlikView

calculation should exclude everything except

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 5 filters like Product, Region, Empname, Site, Month.

When I want to show aggregate number it should change when I click on month.

So I used Sum({<Product, Region, Empname, Site>} Amount) ...its working but I need to mention it in each text box everytime.

DO WE HAVE ANYTHING THAT WILL EXCLUDE EVERYTHING EXCEPT MONTH.

GOOD & EASY WAY

Thanks

narendra

sunny_talwar — Fri, 16 Jun 2017 09:05:32 GMT

Try this

Sum({1<Month = $::Month>} Amount)

Sum({1<Month = p(Month)>} Amount)

UPDATE: Check this link out

swuehl — Fri, 16 Jun 2017 09:06:38 GMT

Maybe have a look at alternate states and only offering the Month listbox to modify the Month selections in that alternate states.