topic Re: Aggregate function in Calculated Dimension in QlikView

Aggregate function in Calculated Dimension

Thu, 18 Sep 2014 05:45:06 GMT

Hi, i want to use aggregate() function in calculated Dimension how can i do? i am doing like below : =TRADES & '-' & MIN(TRADETIME) this is giving me error. Please help Regards, Jitendra K Vishwakarma

Re: Aggregate function in Calculated Dimension

marcus_sommer — Thu, 18 Sep 2014 05:46:47 GMT

See here: http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/08/calculated-dimensions

- Marcus

Re: Aggregate function in Calculated Dimension

ecolomer — Thu, 18 Sep 2014 05:47:44 GMT

You can see also:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr

Re: Aggregate function in Calculated Dimension

Thu, 18 Sep 2014 06:09:46 GMT

Sorry my meaning of aggregate function was i want to use sum() , min() & max() fucntion but it showing error //Error in Calculated Demintion i am using syntax : =TRADES & '-' & min(TRADETIME) actually i want chart on TRADES base only but want to display min(TRADETIME) also Thanks

Re: Aggregate function in Calculated Dimension

Thu, 18 Sep 2014 06:09:51 GMT

Re: Aggregate function in Calculated Dimension

marcus_sommer — Thu, 18 Sep 2014 06:15:25 GMT

You couldn't use a aggregation-function within a calculated dimension without wrapping it in an aggr() - therefore see the links with the very good explanations.

- Marcus

Re: Aggregate function in Calculated Dimension

Thu, 18 Sep 2014 06:30:37 GMT

Thanks Now i can understand