Aggregate function in Calculated Dimension

[#1]

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

[marcus_sommer · Accepted solution]

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

- Marcus

[ecolomer]

You can see also:

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

[#4]

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

[#5]

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

[marcus_sommer]

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

[#7]

Thanks Now i can understand