topic Re: set analysis help in QlikView

set analysis help

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I have the following expression which works as expected. However I don't want it to respond to MONTH selections. Now when I click on any month it still filters to show only that month. Please help!

aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1)),MONTH)

Thanks,

Weiting

Re: set analysis help

vinieme12 — Wed, 07 Dec 2016 18:56:24 GMT

Try

aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)

Re: set analysis help

sunny_talwar — Wed, 07 Dec 2016 19:04:48 GMT

May be this:

Only({<MONTH>}Aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'}, MONTH=>} COMBO_NEW_GOAL_VALUE), 1, MONTH-1)), MONTH))

Re: set analysis help

Wed, 07 Dec 2016 19:09:06 GMT

Thanks Sunny,

I added only function as you suggested but it's doing the same thing... When I filter on any month, it's only showing me that month data point versus the whole year..

Any other ideas?

Weiting

Re: set analysis help

sunny_talwar — Wed, 07 Dec 2016 19:13:03 GMT

I see the issue now, try this:

Only({<MONTH>}Aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'}, MONTH=>} COMBO_NEW_GOAL_VALUE), 1, Only({<MONTH>} MONTH)-1)), MONTH))

Re: set analysis help

vinieme12 — Wed, 07 Dec 2016 19:14:41 GMT

have you tried the below

aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)

Re: set analysis help

Wed, 07 Dec 2016 19:16:30 GMT

Hi Vineeth,

Thanks for the reply. Yes I tried your approach and it doesn't work...

Any other ideas please?

Re: set analysis help

Wed, 07 Dec 2016 19:17:00 GMT

Still filtering on month...

Not sure what's going on...

Re: set analysis help

sunny_talwar — Wed, 07 Dec 2016 19:17:54 GMT

How do you define vKPIChecking?

Re: set analysis help

Wed, 07 Dec 2016 19:19:48 GMT

vKPIChecking= 'New Checking Accounts'

Re: set analysis help

sunny_talwar — Wed, 07 Dec 2016 19:27:57 GMT

Not sure why it is still changing, would you be able to share a sample to look at?