topic Setanalyis and AGRR does it effect without selections though Aggr is based on Dimension? in QlikView

Setanalyis and AGRR does it effect without selections though Aggr is based on Dimension?

Fri, 17 Dec 2010 10:00:53 GMT

I asked in the other thread regarding this Problem but I made it easy here to make Understand. Can anyone Help me with what is going on here. Why If I select some dimension the Values are correct and if I dont select the values are wrong. AGGR() in my expression is responsible for that but How can I solve it??

See the attached example.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Forumproblem143.qvw]

Regards

Sravan

Setanalyis and AGRR does it effect without selections though Aggr is based on Dimension?

Fri, 17 Dec 2010 12:57:52 GMT

Hello,

take a look at my expressions for MinorStops and MinorStops%. I added some aggr()-functions. Secondly I replaced within one of the given aggr() the dimension ActivityDefinitionId with MachineDefinitionId because I assume that you want to aggregate all sum() in one expr. over the same dim.

Regards, Roland

Setanalyis and AGRR does it effect without selections though Aggr is based on Dimension?

Fri, 17 Dec 2010 13:23:00 GMT

HI roland,

Thanks for your answer. The trick is to add as many dimensions as needed. That helped. I still wonder why after adding Aggr(expression, Dim1) etc the MinorStop value for MachineDefinitionID OEE_DV_DEVNAME_45 is 0. I think Aggr does not take Negative Values. It worked with Aggr and without Dimensions but with Aggr and Dimension why it is getting the Previous correct value.

Vielen Dank
Regards

Sravan

Setanalyis and AGRR does it effect without selections though Aggr is based on Dimension?

Fri, 17 Dec 2010 14:13:57 GMT

Hello Sravan,

yes, this is the trick (anyway one of my favorite functions) . I didn't check it right now, but as far as I know does aggr() ignore null-values.

So long, Roland