Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregate function in Calculated Dimension

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

1 Solution
6 Replies
ecolomer
Master II
Master II

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Thanks Now i can understand