topic Re: {<FIELD=>} not working in AGGR() function in QlikView

{} not working in AGGR() function

Thu, 09 Jul 2015 07:33:00 GMT

Hello,

I am using count of FIELD1 across dimension FIELD and using AGGR() to do group by of FIELD2,FIELD3,FIELD4 in a chart. Also i have used {<FIELD=>} as the set modifier so that the selection in FIELD should not reflect in chart. The chart is working unless i don't make a selection in FIELD. As soon as selection is done in FIELD, the chart changes according to the selection thus ignoring the set modifier {<FIELD=>}.

Can someone explain the reason of this different behaviour.

Expression - count({<FIELD=>} AGGR(FIELD1,FIELD2,FIELD3,FIELD4))

Also AGGR(count({<FIELD=>} FIELD1),FIELD2,FIELD3,FIELD4) is not fetching any result, so i used the above expression.

Re: {} not working in AGGR() function

Gysbert_Wassenaar — Thu, 09 Jul 2015 07:42:57 GMT

Why are you using the aggr function? What are you trying to calculate?

Re: {} not working in AGGR() function

jagan — Thu, 09 Jul 2015 07:43:06 GMT

Hi,

Try like this

Sum({<FIELD=>} AGGR(count(FIELD1),FIELD2,FIELD3,FIELD4) )

Hope this helps you.

Regards,

Jagan.

Re: {} not working in AGGR() function

MK_QSL — Thu, 09 Jul 2015 07:43:29 GMT

Looking wrong !

count({<FIELD=>} AGGR(FIELD1,FIELD2,FIELD3,FIELD4))

What you are Counting?

Can you provide sample app or data?

Re: {} not working in AGGR() function

swuehl — Thu, 09 Jul 2015 07:58:56 GMT

If you want to ignore the selection in FIELD, you should consider using a set expression in the inner as well as the outer aggregation.

count({<FIELD=>} AGGR( only({<FIELD=>} FIELD1), FIELD2,FIELD3,FIELD4))

I am not sure if using only() is what you really want here, but it exactely the same inner aggregation you are using in your original (working without selections) expression.

If you want more help, post more details about the context.

Re: {} not working in AGGR() function

Thu, 09 Jul 2015 11:54:29 GMT

its actually counting FIELD1 and then aggregating on FIELD2, FIELD3,FIELD4

Re: {} not working in AGGR() function

Thu, 09 Jul 2015 11:59:25 GMT

Thanks Jagan!

Unfortunately, this expression also is not preventing the expression to change it's value on selection of FIELD.

Can you come up with some other alternate solution.

Re: {} not working in AGGR() function

Thu, 09 Jul 2015 12:01:27 GMT

Gysbert,

i am calculating count of FIELD1 and aggregating on FIELD2, FIELD3.... while keeping the value of FIELD constant.

Re: {} not working in AGGR() function

MK_QSL — Thu, 09 Jul 2015 12:01:46 GMT

SUM({<FIELD = >}Aggr(COUNT({<FIELD = >}FIELD1),FIELD2, FIELD3, FIELD4))

Re: {} not working in AGGR() function

Thu, 09 Jul 2015 12:03:39 GMT

Thanks a ton Manish!

It worked.

thank you so much.

Re: {} not working in AGGR() function

jagan — Fri, 10 Jul 2015 03:58:53 GMT

Hi,

I think instead of using Aggr() and getting count, try like this

LOAD

AutoNumber(FIELD1 & FIELD2 & FIELD3 & FIELD4) AS Key

FROM DataSource;

Count({<FIELD=>} Distinct Key)

Note: Aggr() will have performance issues.