topic Re: Aggr problem in QlikView

Aggr problem

DavidFoster1 — Tue, 28 Oct 2014 00:07:41 GMT

I have the following expression

=CONCAT({$<Stage.YrMthID={'297'}>} AGGR(SUM({$<Stage.YrMthId={'297'}>} [Project Stage Duration]),[Project Id],[Project Stage]),',')

I need this statement to return the results linked to YrMthId 297 irrespective of the actual selected value of YrMthId. But the behaviour I am getting is when I select a YrMthId other than 297 the result is NULL.

I have other filters that I need to include so I need to use the $.

Any ideas?

Re: Aggr problem

jagan — Tue, 28 Oct 2014 03:39:50 GMT

Hi,

Try this

I have a table like this

city	sales
blore	2300000
chennai	5600000
hyd	1000000

=CONCAT({<city={'blore'}>} AGGR(SUM({<city={'blore'}>} sales),city),',')

This expression is working, can you attach some sample file.

Regards,

Jagan.

Re: Aggr problem

Tue, 28 Oct 2014 06:24:36 GMT

It works with $ sign as well.

=CONCAT({$<city={'hyd'}>} AGGR(SUM({$<city={'hyd'}>} sales),city),',')

You might have to check your other selections, that might not match the result set of YrMthId = 297, so either have to deselect it, or ignore them in set analysis.

Thanks,

Singh

Re: Aggr problem

DavidFoster1 — Tue, 28 Oct 2014 06:28:22 GMT

Does it work if you make a different selection in the city field?

Re: Aggr problem

Tue, 28 Oct 2014 06:30:11 GMT

Yes it does David. It works even If I clear selections for the City field. Try selecting any ID other than 297 and deselect all selections. Then one by one add your other selections and see where it is failing.

Re: Aggr problem

jagan — Tue, 28 Oct 2014 06:46:50 GMT

Hi,

It works even for a different selection in the city field, can you attach sample file.

Regards,

Jagan.

Re: Aggr problem

DavidFoster1 — Tue, 28 Oct 2014 07:49:22 GMT

Thanks for testing for me. I must be doing so etching stupid in the app

Sent from my iPad