topic Re: Aggr in Adhoc Report in QlikView

Aggr in Adhoc Report

Mon, 22 Sep 2014 02:57:16 GMT

Hi ,

i am facing an issue , i was not getting the correct sum in expression so i used aggr in expression in Adhoc report . but i have 45 dimensions in adhoc report so dont want to write all the dimensions in the aggr.

so i tried like

=sum(aggr(Count(Distinct [Customer Customer_code]),concat(AdHocTotalCustomer_DimensionTree,',')))

=sum(aggr(Count(Distinct [Customer Customer_code]),GetFieldSelections(AdHocTotalCustomer_DimensionTree))).

These expression did not work for me . Kindly suggest something.

Thanks!!!

Re: Aggr in Adhoc Report

jagan — Mon, 22 Sep 2014 03:55:37 GMT

Hi Saurabh,

Try like this

Create a variable

vSelectedDim ::: =GetFieldSelections(AdHocTotalCustomer_DimensionTree)

and use expression

=sum(aggr(Count(Distinct [Customer Customer_code]), $(vSelectedDim)))

Hope this helps you.

Regards,

Jagan.

Re: Aggr in Adhoc Report

Mon, 22 Sep 2014 04:12:33 GMT

Hi Jagan

Thanks for reply .

i tried the same . its not working.

Regards,

Saurabh

Re: Aggr in Adhoc Report

jagan — Mon, 22 Sep 2014 04:55:35 GMT

Hi,

I checked this in the sample attached in the below link, it is working

Adhoc reporting in Qlikview

Did you given = in variable declaration?

Regards,

Jagan.

Re: Aggr in Adhoc Report

Mon, 22 Sep 2014 05:30:53 GMT

Yes .

i used below mentioned variable & expression. but it did work .

vSelectedDim

=GetFieldSelections(AdHocTotalCustomer_DimensionTree)

Expression

=sum(aggr(Count(Distinct [Customer Customer_code]), $(vSelectedDim)))

Thanks!!

Re: Aggr in Adhoc Report

jagan — Mon, 22 Sep 2014 05:34:36 GMT

Hi Saurabh,

I am not sure about why it is not working, you have any spaces or special characters in field values? If possible attach sample file.

Regards,

Jagan.